Scenario

The health care provider needs to find all the patients who had treated by a doctor Durenda. Doctor's informaion and reports are stored in the PMD documents in XML format.

Operation

The XMLEXISTS predicate checks for the condition specified and returns a boolean accordingly. The example on the right shows that XMLEXISTS returns 'true' if the doctor's given name is 'Durenda' and 'false' if otherwise.

Solution

Patients treated by doctor Durenda are returned.

Best Practices