You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to fetch questionnaire responses for all question types (Text, single choice, multiple choice)

Received Response
513
Views
2
Comments
edited Feb 27, 2023 6:30PM in Journeys 2 comments

Summary:

I have created the checklist, in the task, I have added the questionnaire so once the employee completed the task, I need to fetch the responses which the employee has submitted.

I am using the below query, it is fetching only questions with question type single choice with respect to the answer but I am not able to fetch other questions and answers which have question type text and multiple choice.

 

select distinct

pact.CHECKLIST_NAME,

PATL.TASK_NAME,

hprv.QUESTIONNAIRE_ID,

papf.person_number employee_number,

ppnf.full_name Employee_Name,

MANAGER_NUMBER.managerno Manager_Number,

MANAGER_Name.managername,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!