sort project report on "Task Order" field
I run a custom project report and sort by Milestone's and Task's (sql query at end of post).
In the Project > Kilestone > Task window you can reorder the tasks, is it possible to sort Task's column by the "Task Order" field. See image below.
I have looked at all the fields in the taskdet table and cannot find anything.
I'm running 11.1 Build 11117
Database is MS SQL
Thanks
Sal

- SELECT projectdet .PROJECTID "Project Id",
- projectdet.TITLE "Project Title",
- projectowner.FIRST_NAME "Project Owner",
- md.TITLE "Milestone Title",
- mst.StatusName "Milestone Status" ,
- taskdet.TASKID "Task ID",
- taskdet.TITLE "Task Title",
- tst.StatusName "Task Status",
- taskdet.PER_OF_COMPLETION "Task Percentage Of Completion" FROM ProjectDetails projectdet
- LEFT JOIN TaskToProjects projtotaskdet ON projectdet.PROJECTID= projtotaskdet.PROJECTID
- LEFT JOIN TaskDetails taskdet ON projtotaskdet.TASKID=taskdet.TASKID
- LEFT JOIN TaskToProjects miletotaskdet ON taskdet.TASKID=miletotaskdet.TASKID
- LEFT JOIN MileStoneDetails md ON miletotaskdet.MILESTONEID=md.MILESTONEID
- LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID
- LEFT JOIN AaaUser projectowner ON projectownerdet.USERID=projectowner.USER_ID
- LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID
- LEFT JOIN SDUSer mdo ON md.OWNERID=mdo.USERID
- LEFT JOIN AaaUser mdon ON mdo.USERID=mdon.USER_ID
- LEFT JOIN ProjectStatus mst ON md.Statusid=mst.STATUSID
- LEFT JOIN ProjectStatus tst on taskdet.Statusid = tst.STATUSID
- LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID
- LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID
- LEFT JOIN ProjectEstimations ON projectdet.PROJECTID=ProjectEstimations.PROJECTID
- WHERE projectdet.TITLE LIKE 'SAN%'
- order by 4
New to ADSelfService Plus?