Join asmt metric result table with sc req item table Database View

Shivani_singh · ‎05-15-2025

Hi All,

I want to join tables asmt_metric_result and sc_req_item to create a database views.
Aim is to get field value from RITM for each survey.

Ankur Bawiskar · ‎05-15-2025

try this, but please enhance if that doesn't work

I believe I have answered all your questions.

You can mark multiple responses as correct as per new community feature. So please do the same.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

shantanu_patel8 · ‎05-15-2025

Looks like you have configured survey for requested Items. To achieve this functionality you can follow these steps:

1. Create a database view with Name as per your business requirement.

2. Create view tables for asmt_metric_result and sc_req_item as shown in the screenshot below:

Please mark the answer helpful and correct if it resolves the issue. Happy scripting

-Shantanu

Shivani_singh · ‎05-15-2025

Hi @shantanu_patel8
Values are not coming the table.

shantanu_patel8 · ‎05-15-2025

Check if you have data in asmt_metric_result table and the source field contains the sc_req_item values.

Shivani_singh · ‎05-15-2025

@shantanu_patel8
yes ,it contains.