Report on database view showing value as sys_ids in the report.

[krishna111]

Hello Everyone, Hope all are doing good.

My question is related to database views I have a customer requirement to report on RITM variable responses of a "Line of Service" variable on four different items. These variables are all "Line of Service" but they do not appear in a variable set. My experience tells me that a database view is required and we had created this in the past to connect three tables - "sc_item_option" "sc_item"option_mtom" and "sc_req_item". The issue I'm facing is that I can only find the sys_id references when trying to report, rather than the actual Line of Service values. Is there any way to get the names instead of sys_id values? The sys_id values are shown in the linked report below under the "Value" attribute.

See attached below for the database view and the report

Thanks in advance. Help is appreciated!

Regards

Kumar

[Sukraj Raikhraj]

Check the attributes in the slush buckets, you should be able to add the dot walk values. 

[Aman Kumar S]

Hey,

Found one related article to your issue

You need one additional join for getting display value

https://community.servicenow.com/community?id=community_article&sys_id=59c5c11cdbaed810fb4ae15b8a9619e4