Which query we use to get the data from agile PLM tables?
You may have to be more specific with your question. There are many tables in Agile’s database… ITEM, SITES, ITEM_SITES, BOM, REV, AGILEUSER, NODETABLE, just to name a few. What information are you looking for? If you are looking for Items, a simple query might be as follows:
SELECT * FROM AGILE.ITEM;
There are different types of items (Documents and Parts). Each of those have their own subclasses. The Class/Subclass names are stored within the NODETABLE. The ITEM table only carries the IDs for Class and Subclass. That said, the subclass IDs will all be unique. If you had a subclass of parts called “Design Parts”, and you wanted to get a list of all Design Parts, your query might look like this:
SELECT I.ITEM_NUMBER FROM AGILE.ITEM I
INNER JOIN AGILE.NODETABLE N ON I.SUBCLASS = N.ID
WHERE N.DESCRIPTION = ‘Design Part’;
I hope that helps a little, but without knowing exactly what info you need, that’s about all I can give you.