sort project report on "Task Order" field

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




  1. SELECT projectdet .PROJECTID "Project Id",
  2. projectdet.TITLE "Project Title",
  3. projectowner.FIRST_NAME "Project Owner",
  4. md.TITLE "Milestone Title",
  5. mst.StatusName "Milestone Status" ,
  6. taskdet.TASKID "Task ID",
  7. taskdet.TITLE "Task Title",
  8. tst.StatusName "Task Status",
  9. taskdet.PER_OF_COMPLETION "Task Percentage Of Completion" FROM ProjectDetails projectdet
  10. LEFT JOIN TaskToProjects projtotaskdet ON projectdet.PROJECTID= projtotaskdet.PROJECTID
  11. LEFT JOIN TaskDetails taskdet ON projtotaskdet.TASKID=taskdet.TASKID
  12. LEFT JOIN TaskToProjects miletotaskdet ON taskdet.TASKID=miletotaskdet.TASKID
  13. LEFT JOIN MileStoneDetails md ON miletotaskdet.MILESTONEID=md.MILESTONEID
  14. LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID
  15. LEFT JOIN AaaUser projectowner ON projectownerdet.USERID=projectowner.USER_ID
  16. LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID
  17. LEFT JOIN SDUSer mdo ON md.OWNERID=mdo.USERID
  18. LEFT JOIN AaaUser mdon ON mdo.USERID=mdon.USER_ID
  19. LEFT JOIN ProjectStatus mst ON md.Statusid=mst.STATUSID
  20. LEFT JOIN ProjectStatus tst on taskdet.Statusid = tst.STATUSID
  21. LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID
  22. LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID
  23. LEFT JOIN ProjectEstimations ON projectdet.PROJECTID=ProjectEstimations.PROJECTID 
  24. WHERE projectdet.TITLE LIKE 'SAN%'
  25. order by 4

                  New to ADSelfService Plus?