Scenario

When a patient visits a hospital the doctor after diagnosing the patient's symptoms refer the patient to a specialist in another hospital or lab for test. On further investigation the specialist may remove a symptom if the test goes negative; hence those are removed from the PMD document.

Operation

XML data can also be modified using a stored procedure.


The recipient node in the PMD document is removed by passing appropriate parameters to the stored procedure.

Solution

The symptoms which are no longer true for the patient is removed from the PMD document.