SLQ query : published assignments

[Woody]

Hello,
Using Project server 2003.
I'm looking for the Table and Fields which could allow the SQL query : what
are the assignments (or tasks) which have been published?
Thnaks for any hint.

 

[Ray McCoppin]

Look at the table MSP_WEB_ASSIGNMENTS this is a table of the published
assignments.

Hope this Helps

 

[Woody]

Thanks a lot Ray,

My question was badly formulated. I think that all the assignments which are
listed in this table are "published". My need is to list on one hand all the
published assignments, and on the other hand all the *not published*
assignments. I expected that somewhere a flag named "Published_Assgnt" could
tell me that.

 

[Ray McCoppin]

If you look at the MSP_ASSIGNMENTS table you will find the following feilds

ASSN_UPDATE_NEEDED bit Indicates whether a TeamUpdate message should be
sent to the resource assigned to a task because of changes to the start date,
finish date, or resource reassignments.

ASSN_RESPONSE_PENDING bit Indicates whether an answer has been received
from a TeamAssign message sent to a resource assigned to a task.

ASSN_TEAM_STATUS_PENDING bit Indicates whether a status message has been
received in response to a TeamStatus message sent to a resource assigned to a
task.

even though they talk about TeamStatus these can tell you if they have been
published.

Hope this helps...

 

[Woody]

Thanks a lot Ray!
Good idea! I'll work around that
Thanks again ;-)