I've seen several threads that come close to actually addressing this issue, but I really need very specific help here. I've tried about everything, so I genuinely hope there's a resident expert watching posts today!
I have an xml document wherein the data resides as such:
/root/map/
The nodes I want to filter on are:
patient_first_name
patient_last_name
I'm trying to figure out how to write the xpath query to retrieve data specific to values in those nodes. At this point I'm down to the following and clearly it's not working at all:
/root/map[patient_first_name=$P{PATIENT_FIRST_NAME}];[patient_last_name=$P{PATIENT_LAST_NAME}]
Can someone PLEASE tell me how to write this crazy query? I'm a SQL guru, but XML queries baffle me.
Thank you so very much!
