Task fields in assignments

[Robert Gonzalez]

Hi,

I'm using PSI of Project Server 2007 to obtain a assignment list of current
user (ReadResourceAssignments method). I can use a filter to obtain some
fields, order and filter the query.

My problem is: I want to obtain assignments "mixed" with some task fields
like "priority" and order and filter this assignments by this task fields.

There is some way to insert task fields in a filter for
ReadResourceAssignments? Something like a "join" of Assignment info and Task
info? Any other way?

Thanks in advance,

Robert

 

[Jim Corbin [MSFT]]

It sounds like you're doing a report. If for Project Server 2007, try using
the Reporting database. There are several sample queries in the Project
Server Report Pack in the SDK (
http://msdn2.microsoft.com/en-us/library/bb428831.aspx ).

--Jim

 

[Robert Gonzalez]

Thanks Jim for the response and info, however, I'm not doing a report. I'm
doing my own version of "My Task" PWA View.

There is something that I can do? Can I do this with Reporting Database?

Thanks in advance,