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:

1. 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: