Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
EHS:Multiple Participants on Single Incident
Summary
EHS:Multiple Participants on Single IncidentContent
Hi Team,
For a single incident we are having multiple participant. So I want to know some joining condition which helps me to find correct participant and answer of question.
Below is the SQL
Select R.ANSWER_CLOB
From HRQ_QSTNR_PARTICIPANTS P
, HRQ_QSTN_RESPONSES R
, HRQ_QSTNR_RESPONSES Q
,HRQ_QSTNR_QUESTIONS questns
,HRQ_QSTNR_SECTIONS_VL secb
,HRQ_QUESTIONNAIRES_VL qb
,HNS_INCIDENTS_SUMMARY HIS
Where Q.qstnr_participant_id = P.qstnr_participant_id
and R.qstnr_response_id = Q.qstnr_response_id
and p.QUESTIONNAIRE_ID=qb.QUESTIONNAIRE_ID
Tagged:
0