Skip to main content
Solved

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

  • February 17, 2023
  • 5 replies
  • 174 views

Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+23

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?

Best answer by EqeRobertK

@Alexander Heinze ,

So it should be:

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

 

Good luck

5 replies

EqeRobertK
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • February 17, 2023

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


Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Author
  • Ultimate Hero (Employee)
  • February 17, 2023

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?


  • Superhero (Employee)
  • February 18, 2023

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.

 


EqeRobertK
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • Answer
  • February 20, 2023

@Alexander Heinze ,

So it should be:

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

 

Good luck


Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Author
  • Ultimate Hero (Employee)
  • February 28, 2023

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