SQL custom meta

Forum|Forum|6 years ago
May 17, 2019
1 reply
4526 views

In what SQL table is the custom meta stored. For example, we have custom Objects types & attributes. I'd like to query the SQL database but I don't know in what table this information is stored? Any ideas?

General Customization

Best answer by abhishekarya

Yes, So if these are global attributes, they would be located under following tables:

If they are string type attributes:

StringDefinition and StringValue

Boolean:

BooleanDefinition and BooleanValue

Timestamp

Timestampdefinition and Timestampvalue

Integer

IntegerDefinition and IntegerValue

Definition tables will have attribute name details whereas StringValue will have the value, the connection to EPMDocument will be in StringValue table, A sample query is as follows:

select C.Documentnumber EPMDocNUMBER, A.value2 "attributevalue" from StringValue A,StringDefinition A1, EPMDocument B,EPMDocumentMaster C
where A.ida3a4(+)=B.ida2a2 and B.ida3masterreference=C.ida2a2 and A.ida3a6=A1.ida2a2 and A1.name='attributename'
and B.latestiterationinfo=1;