Sricknight
New Member
I've got the following XML structure and need to get the value in\[code\]<VALUE><![CDATA[PRUEBAS BPM]]></VALUE> \[/code\]I need to check on two conditions :[*]Get to node FIELD[NAME="dependency"] [*]Get to FIELD[NAME="name"]My XPATH is actually written like this\[code\]/TRAIL/ENTITY/FIELD[NAME="dependency"]/ENTITY/FIELD[NAME="name"]/PRIMITIVE/VALUE/text()\[/code\]However, it doesn't bring any data.Is my XPATH written wrongly somehow? How can I sort out the acces to that info in my xml?Any help will be highly appreciated.Here's my XML structure \[code\]<TRAIL> <ENTITY> <FIELD> <NAME>dependency</NAME> <ENTITY> <FIELD> <NAME>codigo</NAME> <PRIMITIVE> <VALUE><![CDATA[906]]></VALUE> </PRIMITIVE> </FIELD> <FIELD> <NAME>name</NAME> <PRIMITIVE> <VALUE><![CDATA[PRUEBAS BPM]]></VALUE> </PRIMITIVE> </FIELD> </ENTITY> </FIELD> </ENTITY></TRAIL>\[/code\]Thanks in advance for your help!As an extra I must add I'm using this XPATH to retrieve info directly from a database.This is my SQL statement (delta is the table's column containing the XML)\[code\]SELECT XPATH('(/TRAIL/ENTITY/FIELD[NAME="dependency"]/ENTITY/FIELD[NAME="name"])/PRIMITIVE/VALUE/text()', CAST( SUBSTRING( delta FROM position('<TRAIL>' IN delta) FOR char_length(delta)) AS ml ) ) FROM aud_huella_expediente\[/code\]