How to show attributes of referenced objects in custom field

[Hauke Wollentin]

Hi all,

assuming three object types:

• building
  • every building has it's ID and name
• room
  • every room has it's ID and name (not unique) and referenced object "building"
• device
  • every device has it's ID and name (not unique) and referenced object "room"

Our collegues should be able to select e.g. a printer out of the "device" object type in a custom field but we would like to show the room and the building in the drop down list of that custom field.

A workaround would be to also import the room and building name into the device object type, but I'm curious if there is a better way without storing stuff multiple times :) 

Thanks in advance,
Hauke

[PD Sheehan · Accepted solution]

The dropdown for insight custom field can only display a single attribute.

Then, on the issue view, you can display additional attributes in what I usually call for my users, the "object card".

So, if you want to show the building and the room in the dropdown, you have to create an attribute that contains those details. You can use an insight groovy automation script to populate that attribute. That script could even catch when a device is moved and update the attribute accordingly.

Something like:

Device FullName= BuildingName -> RoomNo -> DeviceName
or
Device FullName= BuildingName/RoomNo/DeviceName