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

Fetching multiple choice answers from Questionnaire - Recruiting module

Summary:

Hello,

Business needs to fetch answers from a multiple answers list in reporting using SQL.

We understood that the table HRQ_PTCPNT_RESPONSES_V  stores the ANSWER_LIST, for example: 300003201211743,300003201211744,300003201211732,300003201211741,300003201211742,

Now we have the the table HRQ_QSTN_ANSWERS_VL that stores the answers using the query:

SELECT hqat.long_text

from HRQ_QSTN_ANSWERS_VL hqat

, HRQ_PTCPNT_RESPONSES_V hprV

where hprv.answer_list is not null

AND regexp_substr (hprv.answer_list, '[^,;]+', 1) = hqat.qstn_answer_id

Is there a way we can get answers per candidates?

Content (required):

Using HRQ_QSTN_ANSWERS_VL and HRQ_PTCPNT_RESPONSES_V  to get answers per candidates

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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