How to Capture incident ticket details along with Survey Response in Survey_response tableDescriptionThere is query on how we can get the details of the survey along with the task record for which that survey is submitted on a report for survey_response table. But the above report is giving only survey responses but also needed the field for which ticket the response is givenCauseThere is a table which stores the task number and as well as the survey responses with question and value which satisfies the requirement to build a report which will have the task id and as well as the survey responsesResolutionThere are two ways where your requirement of having both the task id and the survey responses:1.Create a database view with left join to tables 'survey_response' and 'asmt_assessment_instance' where the task id is present in the assessment table2.There is an existing table 'task_survey_detail' is having the question response and the task as well