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 
One last help,I am not able to get that field which i want to add in the survey report.
I have attached the screenshot for the field which i want. In sc_req table i am able get the variable but not in Database table 
, Please help me with the last step.
Thank you

[Ankur Bawiskar]

@Shivani_singh 

this is a separate question and nothing to do with the database view question you originally asked and which I answered already.

If you create report on sc_req_item then you will see variables

But if you create report on that database view then variables won't be seen.

If you want you will have to add few more tables to that database view

check this image, add those 3 tables along with your 4 tables and link it with the sc_req_item table

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

[Shivani_singh]

@Ankur Bawiskar 
But without adding those tables ,i got that variable, but its not display in the add columns.
Just want to know why its not appearing.

[Ankur Bawiskar]

@Shivani_singh 

check my below response and see if that helps and works.

[Ankur Bawiskar · Accepted solution]

@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.

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