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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top