How to extract the Answers provided to a questionnaire in LMS through BI Publisher

Summary:

How to extract the Answers provided to a questionnaire in LMS through BI Publisher

Content (required):

Hi,

we configured as an activity in a LMS course a questionnaire. We would like to know how to extract via BI publisher the answers provided by the learners to the questions included in the questionnaire, when the answer type is a free text (we can extract the answers when the answer type is a LOV, using the query SELECT DESCRIPTION FROM HRQ_QSTN_RESPONSE_LIST_V, but we cannot extract the free text answers).

Hoping someone has some suggestions.

Thanks a lot,