jkramer
11-29-2007, 01:28 AM
Hi,
I'm curious about the following.
For a very specific pricing tool in our company, I got the question if it is possible to get the BOM list of any 3D assembly by doing some SQL queries on the Workmanager database.
I know that I can easily query what children an assembly has by looking up CHILD_ELEMENT in wm_ele_links. But I cannot see how many of these children there are in the assembly. I also noticed that Modelmanager can give me a BOM without using Modeling, but Design Management can't.
Is there any info about the numbers of sub-parts in an assembly in the database, or does Modelmanager look into the 3D-files of the assies to know how many instances of each model there are in a certain assembly??? If so, making a BOM with SQL queries is not an option....
Thanks,
regards,
Jaap
I'm curious about the following.
For a very specific pricing tool in our company, I got the question if it is possible to get the BOM list of any 3D assembly by doing some SQL queries on the Workmanager database.
I know that I can easily query what children an assembly has by looking up CHILD_ELEMENT in wm_ele_links. But I cannot see how many of these children there are in the assembly. I also noticed that Modelmanager can give me a BOM without using Modeling, but Design Management can't.
Is there any info about the numbers of sub-parts in an assembly in the database, or does Modelmanager look into the 3D-files of the assies to know how many instances of each model there are in a certain assembly??? If so, making a BOM with SQL queries is not an option....
Thanks,
regards,
Jaap