| 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
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
