Project

General

Profile

1
select xml_nodes.docid, 'originator/individualName/surName' as path, xml_nodes.nodedata, xml_nodes.parentnodeid 
2
  from xml_nodes, xml_documents 
3
 where parentnodeid IN 
4
       (
5
         SELECT nodeid 
6
           FROM xml_nodes 
7
          WHERE nodename LIKE 'surName' 
8
            AND parentnodeid IN 
9
                (
10
                  SELECT nodeid 
11
                    FROM xml_nodes 
12
                   WHERE nodename LIKE 'individualName' 
13
                     AND parentnodeid IN 
14
                         (
15
                           SELECT nodeid 
16
                             FROM xml_nodes 
17
                            WHERE nodename LIKE 'originator'
18
                         )
19
                )
20
       ) 
21
   AND xml_nodes.docid in ('knb-lter-gce.180') 
22
   AND xml_nodes.nodetype = 'TEXT' 
23
   AND xml_nodes.rootnodeid = xml_documents.rootnodeid 
(9-9/11)