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
  • 1,899 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
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
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