Solved

View or table of the IFS characteristics in the attachment section

  • 25 March 2021
  • 4 replies
  • 563 views
K
Rank
Userlevel 1
Badge +1

Is anyone aware of a view or database table of the IFS characteristics showing in the attachments section?

 

Your help is much appreciated.

icon

Best answer by dhlelk 29 March 2021, 19:30

View original
This topic has been closed for comments

4 replies

EntNadeeL
Rank
Userlevel 5
Badge +9

Hi @KanishkaLK ,

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/
Mathias Dahl
Rank
Userlevel 7
Badge +30

Thanks, @EntNadeeL. That’s where it begins, but it is only a small part of the answer :)

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
dhlelk
Rank
Userlevel 6
Badge +15

Hi @KanishkaLK,

I agree with @Mathias Dahl on the fact that Technical Classes are actually a quite big data model.
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 :blush:

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
K
Rank
Userlevel 1
Badge +1

Thank you for sharing your valuable knowledge @EntNadeeL , @Mathias Dahl and @dhlelk :blush:

Terms & ConditionsCookie settings