Views - Checked out Project list with user

S

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
 
A

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
 
S

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.
 
A

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.
 
Top