Query from a complicated JSON

I have a JSON files that has the following: How do I index and query?
{
"HL7PATIENT_RESULT": {
"PATIENT": {
"PatientIdentification": {
"SetIDPID": {
"HL7SequenceID": 1
},
"PatientName": {
"HL7FamilyName": {
"HL7Surname": "0Lab1292"
},
"HL7GivenName": "0Test1292",
"HL7SecondAndFurtherGivenNamesOrInitialsThereof": "NOPATMATCH"
},
"DateTimeOfBirth": {
"year": 1935,
"month": 49,
"day": 20,
"hours": 25,
"gmtOffset": ""
},
"AdministrativeSex": "M",
"Race": {
"HL7Identifier": "U"
},
"PatientAddress": {
"HL7StreetAddress": {
"HL7StreetOrMailingAddress": "529 Main"
},
"HL7City": "Roch",
"HL7StateOrProvince": "CA",
"HL7ZipOrPostalCode": 30345,
"HL7CountyParishCode": "Fulton"
},
"PhoneNumberHome": {
"HL7CountryCode": "",
"HL7AreaCityCode": {
"HL7Numeric":333
},
"HL7LocalNumber": {
"HL7Numeric": 2223333
},
"HL7Extension": ""
},
"EthnicGroup": {
"HL7Identifier": "UNK"
}

		}
	}
}

}

Marion -
The query depends on your mapping.
Can you share the mapping file for this object?

Also how did you convert HL7 into JSON - what was your approach?
-- Matt

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.