Solved

Equipment Object Navigator>All Objects tab: How to display custom field from Serial Object

  • 17 February 2023
  • 5 replies
  • 113 views

Userlevel 6
Badge +18

Equipment Object Navigator>All Objects shows a mix of functional and serial objects. I have added a custom field to the Serial Object entity and would like to display this in the All Objects list. How is that possible? Looking at the existing fields I often see Equipment_Object_API.Method as column name.

 

Maybe someone can elaborate on this entity/view in general. Is the merging of Functional and Serial Object mainly done in the database view?

icon

Best answer by EqeRobertK 20 February 2023, 09:05

View original

5 replies

Userlevel 5
Badge +13

Hi @Alexander Heinze ,

You can make a read only custom field on the LU EquipmentObject with the following expression:

EQUIPMENT_SERIAL_CFP.Get_CF$_<CUSTOM_FIELD>(v.objkey) 

Where <CUSTOM_FIELD> is the id of the custom field at the serial object.

 

Hope this will help you,

Robert

Userlevel 6
Badge +18

Thanks for the quick response @EqeRobertK ! I tried...

EQUIPMENT_SERIAL_CFP.Get_CF$_NBRPISTONS(equipment_object_seq)

...but don’t get any data. Is equipment_object_seq the wrong key?

Userlevel 7

Thanks for the quick response @EqeRobertK ! I tried...

EQUIPMENT_SERIAL_CFP.Get_CF$_NBRPISTONS(equipment_object_seq)

...but don’t get any data. Is equipment_object_seq the wrong key?

Yes, you should literally use the objkey (and v. for view) which is the link between the main table and the custom table.

 

Userlevel 5
Badge +13

@Alexander Heinze ,

So it should be:

IFSAPP.EQUIPMENT_SERIAL_CFP.Get_CF$_NBRPISTONS(v.objkey)

 

Good luck

Userlevel 6
Badge +18

Thanks @EqeRobertK and @anmise ! I had to prefix the expression with “IFSAPP.”, together with “v.objkey” this solved the issue.

Reply