Solved
SQL custom meta
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?
abhishekaryaAnswer
14-Alexandrite
May 17, 2019
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;