Hi,
I am after the xml query to get the results where account paidInd=false. I have masked the namespace definition for security purpose.
<tns:inPatientMedicalClaimRequest xmlns:tns="http://xxx.xxx.xxx" rhboIsoNum="90360009">
<claim claimTypeCde="xx" facilityId="12545" fundBrandId="ABC" accountReferenceId="0000" accountPaidInd="false"
I have used the below query but it did not work. Any help is highly appreciated.
SELECT TOP 1 cast(xml_request AS XML) AS xml_response
INTO #temp
FROM xx
DECLARE @t TABLE (x XML)
INSERT @t
SELECT xml_response
FROM #temp
SELECT x.value('(/*:inPatientMedicalClaimRequest/claim/', 'varchar(100)') AS accountPaidInd
FROM @t
WHERE x.exist('(/*:inPatientMedicalClaimRequest/claim/accountPaidInd[contains(.,"false")])') = 1
Regards,
kccrga