Is anyone aware of a view or database table of the IFS characteristics showing in the attachments section?
Your help is much appreciated.
Best answer by dhlelk
View originalIs anyone aware of a view or database table of the IFS characteristics showing in the attachments section?
Your help is much appreciated.
Best answer by dhlelk
View originalThank you for sharing your valuable knowledge
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.
Thanks,
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.