OTI Query for Fetching Free Text Fields from Questionnaire
Dear Community,
I am working on an OTBI report and need some help with querying data from a questionnaire called "Student Touchbase". The Questionnaire consists of several pick-list selection fields and free text fields.
Here's the issue I am facing:
- Pick-list Selection Fields:
My query works perfectly for fetching data from pick-list selection fields. Here's the query I use:
Max(CASE WHEN "Questionnaire Question"."Question Text" Like '%4. The amount of work%' then "Questionnaire Question"."Response List Long Text" END)
2. Free Text Fields
However, when I try to fetch data from the free text fields, the above shared query doesn't work(I changed field name from pick-list to free text field) unless I add "by ("Worker"."Person Number"))". Here's the modified query that works: