How to combile asmt_metric_result and incident table.

[B Ashok]

Hello Team, 

I don't have assignment group in the asmt_metric_results table. I need to combine asmt_metric_result and incident tables to get the assignment name of the survey result. 

Please help,

Thansk 

[Danish Bhairag2]

Hi @B Ashok ,

U can create a database view n add both the tables in it n join them using where clause.

Check this small video on how to create 1

https://youtu.be/2Hlns3wBtWk?si=BjX0p3-chygW2zCK

Thanks,

Danish