Is anyone aware of a view or database table of the IFS characteristics showing in the attachments section?
Your help is much appreciated.
Solved
View or table of the IFS characteristics in the attachment section
Best answer by dhlelk
Hi
I agree with
You might be able to re-use the below query with a few modifications,
SELECT NVL(tst.value_text, tst.value_no) value
FROM &AO.technical_object_reference tor,
&AO.technical_specification_tab tst,
&AO.technical_attrib_both tab
WHERE tor.technical_spec_no = tst.technical_spec_no
AND tor.technical_class = tab.technical_class
AND tst.attribute = tab.attribute
AND tab.description = 'Valve Body Model' --Recommended to use tab.attribute instead of tab.description
AND tor.lu_name = 'EquipmentObject'
AND tor.key_ref = (SELECT &AO.Client_SYS.Get_Key_Reference_From_Objkey(lu_name_ => tor.lu_name,
objkey_ => Equipment_Object_API.Get_Objkey(contract_ => '&SITE',
mch_code_ => '&OBJECT_ID')
) key_ref
FROM sys.dual)
;Hope this helps 
Cheers !
Dhananjaya.
This topic has been closed for comments
+10Hi
TECHNICAL_OBJECT_REFERENCE view contains the records and KEY_REF field has the mappings to the functional object.
API : TECHNICAL_OBJECT_REFERENCE_API
Regards,
Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
+32Thanks,
That view/table is the “header” that connects the list of attributes to the object. The actual values lie in another view/table. You can have a look at the values with this example query:
SELECT * FROM technical_specification WHERE value_text IS NOT NULL AND rownum < 30;
I don’t want to go into more detail. With some SQL tool, you can browse around the different table that has a name that starts with “TECHNICAL” to get an understanding of how it all fits together. It’s actually a quite big data model with around 10 different “views” involved.
/Mathias
+15Hi
I agree with
You might be able to re-use the below query with a few modifications,
SELECT NVL(tst.value_text, tst.value_no) value
FROM &AO.technical_object_reference tor,
&AO.technical_specification_tab tst,
&AO.technical_attrib_both tab
WHERE tor.technical_spec_no = tst.technical_spec_no
AND tor.technical_class = tab.technical_class
AND tst.attribute = tab.attribute
AND tab.description = 'Valve Body Model' --Recommended to use tab.attribute instead of tab.description
AND tor.lu_name = 'EquipmentObject'
AND tor.key_ref = (SELECT &AO.Client_SYS.Get_Key_Reference_From_Objkey(lu_name_ => tor.lu_name,
objkey_ => Equipment_Object_API.Get_Objkey(contract_ => '&SITE',
mch_code_ => '&OBJECT_ID')
) key_ref
FROM sys.dual)
;Hope this helps
Cheers !
Dhananjaya.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.