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

[Shivani_singh]

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.

[Shivani_singh]

@Ankur Bawiskar 
Along with the Survey response ,I want to show variable for that particular catalog.
The logic what you gave ,didnt worked out
I have attached the screenshot; can you please me to fix it.
Thank you

[Ankur Bawiskar]

@Shivani_singh 

I already informed it should work if you have taken surveys in past for RITM table

If not then it won't show any records in database view

To confirm if my logic works, I updated the table as sn_customerservice_case to see Survey responses on Case records and it worked fine

sc_req_item table also extends task

See below it showed me only Survey responses taken on Case table

Also I have records for Case table in Assessment Instances, do you have any for sc_req_item table?

if not then it won't show.

Approach I shared is correct, it's just that you don't have data to render

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

[Shivani_singh]

@Ankur Bawiskar 
It is working now.
Thank you for your efforts.
But still i can't see the field which i want to add in the report which is present in sc_req_item table .
Should i need to add anything else.
Can you please help me on this.

[Ankur Bawiskar]

@Shivani_singh 

Glad to know that my approach worked for you.

Please mark my response as correct and close the thread as I answered your original question and the discussion can continue on the same thread.

[Ankur Bawiskar]

@Shivani_singh 

which field of RITM you want to see?

If you are still using task table then replace that database table with sc_req_item table and update the where clause as this then

like this you can update in the OOTB one or create a database view similar to OOTB and just use sc_req_item table instead of task table

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