database view on 3 tables

[mregragui_ext]

Hello i want to create a database view on those 3 tables asmt_assessment_instance, asmt_assessment_instance_question, and task based on ticket number .

Can someone help me to do this.

Thanks

[AndersBGS]

Hi @mregragui_ext ,

Why create a database view when you can dot-walk OOTB?

Create a report based on the [asmt_assessment_instance_question].

You then have the question, the instance, and can dot-walk by instance.task to the task table as shown above.

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]

Hi @AndersBGS 

Because i need information in asmt_assessment_instance can you help me with joining the 3 tables ?

[Uday Soni05]

Hi @mregragui_ext ,

I agree with @AndersBGS point that we can build the report from asmt_assessment_instance_question table and you can dot walk to get the instance and instance.task from question itself
You can choose the columns whatever you want
Refer Below Screenshots:

Navigate to Configure>Choose Columns and you can choose columns from Instance field as well

Click the highlighted icon and you can choose the fields from instance table

Similarly for instance.task

So your final report will have the fields from all the three tables

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

[mregragui_ext]

@AndersBGS  i need a database view where all tasks are visible and the survey results in the asmt_assessment_instance_question i only have the tickets that has a survey