Yes, the document is quite large with 80 questions and other information I
wanted to just include the relevant information.
Below has all the elements up to the 2 questions from 2 separate
questionnaires. If the QuestionnaireIdentifier_GCC__c is equal to
<Safety_MedicalAE Questionnaire> then I want the Response_GCC__c from there.
<?xml version="1.0" encoding="UTF-8"?>
<records xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/
xmlns="urn:enterprise.soap.sforce.com"
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
xmlns:sf="urn:sobject.enterprise.soap.sforce.com"
xsi:type="sf:Case">
<sf:Id>xxxxxxxxxxxxx</sf:Id>
<sf:Case_Responses_GCC__r>
<records xsi:type="sf:Response_GCC__c">
<sf:QuestionnaireQuestion_GCC__r
xsi:type="sf:QuestionnaireQuestion_GCC__c">
<sf:DSMapping_GCC__c>Indication</sf:DSMapping_GCC__c>
<sf:Questionnaire_GCC__r xsi:type="sf:Questionnaire_GCC__c">
<sf:QuestionnaireIdentifier_GCC__c>Safety_MedicalAE
Questionnaire</sf:QuestionnaireIdentifier_GCC__c>
</sf:Questionnaire_GCC__r>
</sf:QuestionnaireQuestion_GCC__r>
<sf:Response_GCC__c>rash</sf:Response_GCC__c>
</records>
<records xsi:type="sf:Response_GCC__c">
<sf:QuestionnaireQuestion_GCC__r
xsi:type="sf:QuestionnaireQuestion_GCC__c">
<sf:DSMapping_GCC__c>Indication</sf:DSMapping_GCC__c>
<sf:Questionnaire_GCC__r xsi:type="sf:Questionnaire_GCC__c">
<sf:QuestionnaireIdentifier_GCC__c>Safety_Medical_FULL
Questionnaire</sf:QuestionnaireIdentifier_GCC__c>
</sf:Questionnaire_GCC__r>
</sf:QuestionnaireQuestion_GCC__r>
<sf:Response_GCC__c>cough</sf:Response_GCC__c>
</records>
<size>80</size>
</sf:Case_Responses_GCC__r>
</records>
|