SELECT i.item_number As “Parent Item”,a.item_number As “Component”,LEVELFROM AGILE.BOM A,agile.item iwhere a.item=i.id and level=1START WITH (A.ITEM In (SELECT DISTINCT i.idFROM agile.item i, agile.bom bWHERE i.id = b.item AND i.item_number in (‘500040-505’))AND Read More
Add Log administration
Enabling SQL Trace for versions 9.3 and later can be done without restarting the application server: 1. Log into Web Client as the user with administrator role, go to Administration>Logging Configuration Read More
Agile personal searches messes up
In agile plm if the user’s persoanl searches messes up, run the below query and check is the exact user ids are facings problemsselect * from query where type=0 and Read More
Enovation Of PLM
One of the topics that people often ask is what is the difference between PDM and PLM. The question is almost rhetoric, since the number of explanation is +1 from Read More