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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

OTI Query for Fetching Free Text Fields from Questionnaire

edited Jun 7, 2024 9:50AM in Reporting and Analytics for HCM 14 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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