SQL custom meta

[Darquise]

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?

[abhishekarya]

hello,

you mean you created IBAs and Soft Types or you created Custom Hard Model types?

[AshleyHolmes]

it would the 'more attributes' tab in the document information (we renamed to say Metadata)

(see attached screen shot from windchill document i )

which sql table stores this information?

[Darquise]

in Type & Attributes, I created sub-types under EPMDocument. I then created custom attributes which i added to my subtype. Does that make sense?

[abhishekarya · Accepted solution]

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;

[Darquise]

Getting close! Thank you 🙂

I'm getting an error at:

A.idA3A4(+) = B.idA2A2

Incorrect syntax near ')'

[Darquise]

ohh, that's for Oracle right. In SQL, it would be something like this:

from StringValue A right outer join EPMDocument B on A.idA3A4 = B.idA2A2

[abhishekarya]

Yes sorry i assumed Oracle.