Skip to main content

I have an Object-ID which is nested below two layers of Object-IDS i.e

 

Customer Name > Plant Room > Piece of Equipment

 

I want a custom field against the 2nd & 3rd level object-id that will show the top level object-id number. There is already a field called ‘Superior Object’, however, this only shows one level above. This would work find for anything at the 2nd level, but not for anything at the 3rd level.

 

I was trying to find an API that would pick up top_level_parent (similar to what you can do for work order structure) but to no avail.

Hi @hwilkie ,

Have you raised this topic related to FSM or MWO?

Hi - I’m not sure what your question is?

In which application do you try to do the custom field? if it is in IFS Applications you can try this SQL:

SELECT mch_code
FROM equipment_object
WHERE sup_mch_code IS NULL
CONNECT BY PRIOR mch_code = sup_mch_code
AND PRIOR contract = sup_contract
START WITH mch_code_ = :mch_code
AND contract = :contract

Tomas’ answer, adjusted for IFS Cloud 22r1

SELECT mch_code
FROM equipment_functional
WHERE functional_object_seq IS NULL
CONNECT BY PRIOR functional_object_seq = equipment_object_seq
START WITH equipment_object_seq = :equipment_object_seq

Reply


Terms & ConditionsCookie settings