Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL non-functional in PPM database

SOLVED
Go to solution
Highlighted
sam.greg
Senior Member

SQL non-functional in PPM database

Hi,

In PPM database, I could see many columns for a table - req no, date, manager, parameter1, visibleparameter1, p2,vp2...p40,vp40.

But, when I try to use SQL statement to view this table - "select * from tabel" it shows only - ren no, date, manager. It does not show p1,vp1,p2,vp2...etc

Any idea why it is like that?


Thanks in advance

Regards,
Sam.
2 REPLIES
Niraj Prabhu
Frequent Visitor
Solution

Re: SQL non-functional in PPM database

Sam,

This is more over a Database issue, Try contacting Database Administrators to figure out if the Table definition or any access grants is stopping for this.

Thanks!
Niraj
Niraj P.
sam.greg
Senior Member

Re: SQL non-functional in PPM database

Thanks Niraj. It was an issue with my privileges.
//Add this to "OnDomLoad" event