Report with sysID instead of name values

[dev_K]

Hello,

I have created a report but I see that some of the values are not the name values but sysId. Is there a way to change it?

[Runjay Patel]

Hi @dev_K ,

For reference field you will get sysid, you can use getDisplayValue if you are using script to generate this report.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[SumanthDosapati]

@dev_K 

Which table are you using?

Irrespective of table, If its a reference field then you will get display value in report. If its a string field which stores sysid then you cannot show the display value.

Regards,

Sumanth

[dev_K]

Hi,

thank you for looking into this.

the table is sc_item_option_mtom, i want to see the RITMs and all the variables per selected catalog item. Indeed, it is the reference fields that cause this issue. Eg. 'Requested for' references sys_user table and indeed, only sysID are shown... How can I create a report that will show the actual values?

[Papai Ghosh]

Hi @dev_K ,

Please try to create the report from sc_req_item table,I think from there you can also get the variable values ,but the issue in sc_item_option_mtom table is there is one depended item which always comes with sys_id Values .So I think If you can manage to make the report with sc_req_item table, that woud be best.

Thanks & regards,

Papai