We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

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

Go to solution
Shivani_singh
Tera Contributor

‎05-15-2025 03:41 AM

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.

 
0 Helpfuls
  • 3,670 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
In response to Shivani_singh

‎05-15-2025 07:29 AM

@Shivani_singh 

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.

AnkurBawiskar_1-1747319240222.png

 

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

View solution in original post

21 REPLIES 21

Go to solution
Shivani_singh
Tera Contributor
In response to Ankur Bawiskar

‎05-15-2025 10:41 AM

@Ankur Bawiskar 
The field is coming as empty ,is there something wrong i am doing .
Have attached the screenshot.
Thank you so much for your time and effort ,will mark the solution as helpful.

Preview file
86 KB
Preview file
229 KB
0 Helpfuls

Go to solution
Ankur Bawiskar
Tera Patron
In response to Shivani_singh

‎05-18-2025 08:34 PM

@Shivani_singh 

I believe I have answered your original question and subsequent questions as well.

Please mark my response as correct and close the thread.

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