How to get count of childnodes in XML file using XQuery

Question

I want to get or return the number of item(<recROw></recROw>) in an xml file using the XQUERY. Is there an easy way to do that in XQuery?

Here is my sample XML data:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DailyRecord>
  <recROw>
    <id>1</id>
    <name>John Smith</name>
    <gender>male</gender>
    <status>active</status>
  </recROw>
  <recROw>
    <id>2</id>
    <name>James Bond</name>
    <gender>male</gender>
    <status>active</status>
  </recROw>
<DailyRecord>

Any help and ideas would be appreciated. Thank you in advance!

[What have you tried?](http://www.whathaveyoutried.com/) I mean *besides* asking us. — Andrew Thompson, Jun 21 '13 at 04:41

score 3 · Accepted Answer · edited Dec 04 '18 at 20:07

3

Try

count(/DailyRecord/recROw)

edited Dec 04 '18 at 20:07

Michael J Swart

3,060
3
29
46

answered Jun 21 '13 at 07:27

Michael Kay

156,231
11
92
164

3

Okay. Sorry I'm just a beginner about XQuery and Java. Thanks for downing! – napstyr maceda Jun 21 '13 at 07:47
3

upvoted the question, thank you for posting your question in a precise manner. – Dave Kelly Mar 03 '16 at 19:22

How to get count of childnodes in XML file using XQuery

1 Answers1