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