Home » Applications » Primavera » Trying to find field in database (PPM - Oracle - Windows)
Trying to find field in database [message #647034] Mon, 18 January 2016 10:41 Go to next message
bvandyke
Messages: 2
Registered: January 2016
Location: US
Junior Member
Been asked to develop report that shows status of "Ignore relationships to and from other project" option. We have 20+ projects and this needs to be checked twice a day for each.

I've been all over the schema but I can't seem to find where this is stored.

Any help would be great.

Thanks
Re: Trying to find field in database [message #647151 is a reply to message #647034] Wed, 20 January 2016 10:53 Go to previous messageGo to next message
bvandyke
Messages: 2
Registered: January 2016
Location: US
Junior Member
I found it myself.

It is in a BLOB field in the projprop table.

Thanks all that looked.
Re: Trying to find field in database [message #649180 is a reply to message #647151] Wed, 16 March 2016 03:02 Go to previous message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
More specifically, it is the PROP_VALUE column in the PROJPROP table.

desc admuser.projprop;

Name              Null     Type          
----------------- -------- ------------- 
PROJ_ID           NOT NULL NUMBER(10)    
PROP_NAME         NOT NULL VARCHAR2(32)  
PROP_VALUE                 BLOB          
UPDATE_DATE                DATE          
UPDATE_USER                VARCHAR2(255) 
CREATE_DATE                DATE          
CREATE_USER                VARCHAR2(255) 
DELETE_SESSION_ID          NUMBER(10)    
DELETE_DATE                DATE  



Regards,
Lalit
Previous Topic: installed primavera
Next Topic: Primavera P6 Dbsetup.bat
Goto Forum:
  


Current Time: Wed Dec 13 05:30:54 CST 2017

Total time taken to generate the page: 0.16912 seconds