Display Value of a Referenced List in a report

Daryll Conway · ‎05-18-2015

I have a list on my form which is a reference to the cmdb_ci table.

When viewing on the form I have no problem the sys_id in the field is converted to the display value (name).

However when users look for the CI Name in a report they find nothing.

If I use the sys_id in the report I find what I was expecting but this isn't very user friendly.

Can anyone tell me how I can get the report to search for the CI name rather than the sys_id?

I can't get 'show related field' in the report to show the referenced fields it just shows as the single field on the form with no drill down to the related table.

Daryll Conway · ‎05-18-2015

It's actually the filter I need to use the CI Name for but if I get it in the columns slush bucket I'm sure it'll be here as well.

Daryll Conway · ‎05-18-2015

Is your example above using a list field as the reference field, or is your example a normal reference field (single entry)?

Pradeep Sharma · ‎05-18-2015

Hi Daryll,

Sorry for delay in my response. For list fields + icon will not be available. I was assuming here the field as reference earlier from your post. However I've just created a field of type list reference to sys_user table and it shows the display value on the report as expected.

Also if you can try to reproduce on any demo instance we can take a look.

Please let me know if you have any questions.

Daryll Conway · ‎05-19-2015

If you do a filter in your report for the display name do you find anything?

e.g:

If I do this ...

I get results but nothing for the display name

randrews · ‎05-18-2015

on a list like that the reference field should show the display value not the sid...we have several lists configured that way off of sys_users and the list views show the users not their sid....

i would check the table that the list value is on and verify that there is ONLY one column listed as display is true.. the system will let you set two of them as true but it messes things up.