Creating database view between metric result and Assessment Instances

[mregragui_ext]

Hello community, i want to create a database view with left join between Assessment Instances and metric result to have all the result of the two tables combined.

This is an urgent need can someone help me on this.

Thanks

[AndersBGS]

Hi @mregragui_ext ,

Why create a database view when you can "just" dot-walk from asmt_metric_result --> asmt_metric_instance:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[mregragui_ext]

@AndersBGS Because I need also the survey sent and not answred 

[AndersBGS]

Hi @mregragui_ext ,

Ok, then you could also look at the table "asmt_assessment_instance_question" which contains both question answered and not answered, and you can dot-walk to the instance if needed.

Not answered = value is empty

Answered = value is not empty

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[mregragui_ext]

@AndersBGS  please can i access the value of satisfaction from the  Assessment instances tables?