Determining attribute configuration from a query
I’m looking for a way to query the Agile database for some configuration information. For a given part subclass, there may be page 3 attributes that I’ve selected to be visible, given a specific name, attribute type (text, list, multilist, etc.). There is a table named PROPERTYTABLE which appears to have the information I need, but the values within that table are typically IDs. What tables do I need to join with to get the textual information I’m looking for? Thanks.
NODETABLE.ID = PROPERTYTABLE.PARENTID, for your purposes. The list ID for PROPERTYTABLE.PROPERTYID is 181, which tells you which property is specified.
Note that just about everything in the configuration starts in NODETABLE. Classes are OBJTYPE=5, and then things head down in a hierarchical fashion where current ID = PARENTID of the next level down. Classes are not the only thing, obviously, and the list ID for nodetable object type is 101.
Lots more to discover, but neither Agile nor Oracle has ever published anything about how the schema works.