We are running into issues that we have found with surveys and survey results. We have a field in the SurveyQuestions Table called "ISMANDATORY" with each questions having a value of True, but does not make the questions actually mandatory.






We have had many instances where surveys are submitted without all questions answered. This does not accurately report the results of the survey when we pull the results for our own reporting purposes. I have been working on a query to filter out surveys that have not been fully completed, but have been struggling to do so (previous ticket put in for assistance with that - TicketID 4114857). Please find an example of the survey instance below: