Skip to main content

Hello,

 

I would ask you a question. My task was to create quick report, which will retrieve only those items, which dont have any superior items (part => Component Where Used) , this is my SQL code: 

 

“SELECT b.part_no, a.component_part, b.description
FROM INVENTORY_PART b 
FULL JOIN MANUF_STRUCTURE a ON a.component_part = b.part_no 
WHERE b.part_no IS NOT NULL AND a.component_part IS NULL
ORDER BY b.part_no ” 

 

and I have SQL query which will retrieve those items which have superior items:

 

“SELECT b.part_no, a.component_part, b.description
FROM INVENTORY_PART b 
FULL JOIN MANUF_STRUCTURE a ON a.component_part = b.part_no 
WHERE b.part_no IS NOT NULL AND a.component_part IS NOT NULL
ORDER BY b.part_no”

 

According to the IFS cloud, item with part_no = M001541 has no parent part (superior item), but in SQL had 3 superior items. 

 

can you select for the CONTRACT and see if it is a different site/CONTRACT which is having components?

It is working on both contracts, but unfortunately in some cases (15 yet) in IFS has no superior item and in SQL has at least one. Or maybe it was deleted from IFS cloud but in SQL it stayed unchanged.

Which screen are you using in IFS to determine whether a part has superior items?

Is it possible that your SQL results are showing all sites, but your results in IFS are being restricted by either site or company permissions?

I suspect the IFS client is restricting the display of certain parts - rather than them being deleted or anything else.

Are you able to log into IFS as a superuser which has access to all companies and sites and see if you get the same results?

Reply


Terms & ConditionsCookie settings