How to get TASK_ID field for summary tasks without using Project.a

[Nikhil]

I know for tasks which are not summary tasks we can get TASK_ID field using
statusing web service. But i could nto find any other options than Project
web service to get TASK_ID field for summary tasks and the top level project
task.

Problem of using Project web service is that in my custom sharedpoint web
part where we are using PSI web services we get all the data required using
Resource and Statusing web service for the logged in resource. But Statusing
web service retrieves TASK_ID only for actual tasks and not for summary
tasks.

Now just to get TASK_ID of summary task i will unneccessarily have to call
ReadProject method of Project web service which retrieves entire project
dataset out of which i will have to access Task data table and get TASK_ID
field value for summary tasks. EXTREMELY EXPENSIVE WAY OF DOING just to to
get TASK_ID

Any other easy way out ? Pleas help.

 

[virsharma]

You can get the task related values from a db view MSP_EpmTask_UserView (
Reporting Database), further if you need to filter for Summary task only, it
can be done from TaskIsSummary field.

Regards,
Virsharma

 

[virsharma]

You can get the task related values from a db view MSP_EpmTask_UserView (
Reporting Database), further if you need to filter for Summary task only, it
can be done from TaskIsSummary field.

Regards,
Virsharma