cmdb_class_info

[begsa]

I want to display the cmdb_class_info in a drop down from the portal view for the user to select.  When I do that I just get class name, but I want to also show the display name to the user.  

This is what I have displaying on the catalog item variable

When I go to the referencing class (cmdb_class_info)

I am able to see the display  name

How can I get the display name that is more user friendly to show up on the dropdown for the catalog item?  The variable I currently have is a lookup select box

[begsa · Accepted solution]

Thank you for your suggestions, there is no easy way to extract the information we wanted, but we got around it by adding a column on the cmdb_class_info table for a friendly name and added it to the look up field on the variable