OraFAQ Forum: Primavera » Trying to find field in database

Home » Applications » Primavera » Trying to find field in database (PPM - Oracle - Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trying to find field in database [message #647034]

Mon, 18 January 2016 10:41

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

Report message to a moderator

Re: Trying to find field in database [message #647151 is a reply to message #647034]

Wed, 20 January 2016 10:53

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.

Report message to a moderator

Re: Trying to find field in database [message #649180 is a reply to message #647151]

Wed, 16 March 2016 03:02

Lalit Kumar B
Messages: 3174
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

Report message to a moderator

Previous Topic:	installed primavera
Next Topic:	Primavera P6 Dbsetup.bat

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 16:33:59 CDT 2025