It works. Thanks alot 🙂

I thought to much

according your code, I think I know how to change it. thanks a lot.

Your code works, thanks.

but what I need is that, I can query all xml files in whole table at one time, each xml file has thousands events, and each event...

<content xsi:type="OBSERVATION" archetype_node_id="openEHR-EHR-OBSERVATION.blood_pressure.v1" xmlns="http://schemas.openehr.org/v1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<name>

<value/>

</name>

<protocol xsi:type="ITEM_TREE" archetype_node_id="at0011">

<name>

<value>protocol</value>

</name>

</protocol>

<data archetype_node_id="at0001">

<name>

<value>data</value>

</name>

<origin xsi:nil="true"/>

<events xsi:type="POINT_EVENT" archetype_node_id="at0006">

<name>

<value>any event</value>

</name>

<time>

<value>2013-06-19T09:20:00</value>

</time>

<data xsi:type="ITEM_TREE" archetype_node_id="at0003">

<name>

<value>data</value>

</name>

<items xsi:type="ELEMENT" archetype_node_id="at0004">

<name>

<value/>

</name>

<value xsi:type="DV_QUANTITY">

<magnitude>140</magnitude>

<units>mm[Hg]</units>

<precision>0</precision>

</value>

</items>

<items xsi:type="ELEMENT" archetype_node_id="at0005">

<name>

<value/>

</name>

<value xsi:type="DV_QUANTITY">

<magnitude>99</magnitude>

<units>mm[Hg]</units>

<precision>0</precision>

</value>

</items>

</data>

</events>

</data>

</content>

there are many <events/> tags, I just paste one.

thanks