1 Reply Latest reply on Mar 23, 2017 3:01 PM by Lee CS Young

    EPDM Storage of Configuration ID's vs SW

    Guy Edkins



      I am using the Document Manager to extract an assembly structure. The XML stream give you structure, but no custom properties. My idea was to then use the DM to go back to the files (I have the path from the XML stream) and grab them and marry them up. Alternatively I could go to EPDM (SQL directly) to get the custom property values as well.


      With configured items (parts & assemblies) the XML stream outputs the used configuration by file name and a swConfigurationID, which is unique within that file. This is the "hook" to get the configuration.  It appears that when you check a configured part into the vault the configurationID created/stored in the SQL tables is not related to the swconfigurationID found in the item that is configured. Am I missing something here (different table), etc.


      What I need to do is get for any single configuration its actual custom property description and it appears that doing this in EPDM is somewhat circuitous, i.e. a few subqueries vs. a single select statement.  Anyone have any thoughts on this or an approach I am not seeing.