Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
Hi Aditya,
Could crack anything on this?
Regards,
Durga
A DB table browser I found was always helpful in figuring out relationships. Once you browsed enough of them you see a strong pattern in their generation. IDA2A2 is a row ID. If there is a link to a specific item, iteration, etc, the link table will refer to this number mainly. Exception would be for version links. You'll notice links to other tables in the form of IDA...something something (ex: IDA3B5 or IDA3B3). Right next to that column is typically a class name with a similar column heading. That indicates what table the IDA... column adjacent is linked to. You can search for that column and look for the IDA2A2 that matches there linked reference. There is also strong correlation in URLS to table names or something similar. Not always and everything but without a rational rose model, it should not take long with Toad or SQL Developer to go hunting and find what you need.
So to my knowledge, PTC doesn't necessarily share the complete data model and table relationships... There are several articles that show the data model for certain objects.
Here is a data model support page for reporting purposes:
Also, for exploring database tables there is a tool called SQL Developer which may help visualize table relationships
The best way to attack such problem is to run the find_ida2a2.sql with the ida2a2 of an object ,this will return all tables where this id is referenced and relationship columns .
Attached is the one I use with Oracle .
You may also look at https://www.ptc.com/en/support/article/cs137012