Views - Checked out Project list with user

[ss028955]

I need to create a views which shows a list of Project that are checked out
to the users. Can some one help?

Thanks in Advance
ss028955

 

[Andrew Jacks]

G'Day,

Try this SQL against the Published DB

SELECT PROJ_UID, PROJ_NAME, PROJ_CHECKOUTBY, r.RES_NAME FROM MSP_PROJECTS
INNER JOIN MSP_RESOURCES r ON r.RES_UID = PROJ_CHECKOUTBY
WHERE PROJ_CHECKOUTBY is not null

Note that these tables might change during service packs and access data
from any Database bar the Reporting DB is not reccommended.

Have Fun

 

[ss028955]

Nope Andrew. All the project whether it is checked out or not, the
PROJ_ChECKOUTBY value in MSP_PROJECTS table under Published Dabase appears to
be Null.

 

[Andrew Jacks]

G'Day again,

Are the Projects you want to report on Published or not?

If they are not published then ron the sproc against the Draft Database.