Equipment Object Parent Object-ID

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