XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » count in xquery
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2016)
-> + Problems with FTP upload via X... (3)
-> + What path notation works when ... (6)
-> - Xquery Exception (1)
-> + [java] [Fatal Error] Test.xml:... (2)
-> + unable to produce correct XML ... (2)
-> + where can I find stylusxql uti... (3)
-> + Trouble Mapping Multiple Eleme... (3)
-> - input parameter (1)
-> - set element value (1)
-> + Xquery Performance Issue (21)
-> + Run Xquery Program using Java (3)
-> + XQuery XML to CSV (3)
-> + XQuery MySQL connector (4)
-> + XQuery with JDBC connection is... (3)
-> + Create FTP Server (2)
-> + XQuery Nested Loop Lookup (5)
-> + Xpath using a Variable for [@I... (2)
-> - My xqDoc option is disabled. (1)
-> + Xpath ancestor selection (4)
-> + Exception: sequence of more th... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
pattex007 ex007Subject: count in xquery
Author: pattex007 ex007
Date: 10 Jul 2012 10:42 AM
Originally Posted: 10 Jul 2012 10:24 AM
I'm trying to count the guests per hotel between a specific date but i dont get any values with this xquery. What am i doing wrong here ?



xquery version "1.0" ;
<system>{
for $hotel in doc("doc.xml")//Hotel
let $hotelName := $hotel/@name
return
<Hotel Name="{($hotelName )}" >
{
let $beginWeek := fn:current-date() - xs:dayTimeDuration(concat('P', 7, 'D'))
let $endWeek := fn:current-date() - xs:dayTimeDuration(concat('P', 1, 'D'))

for $beginDate in $hotel/reservation/@begin_date
for $endDate in $hotel/reservation/@end_date

where ($beginDate gt $beginWeek and $beginDate lt $endWeek ) and
($endDate gt $beginWeek and $endDate lt $endWeek )

return
<day date="{ count($hotel/reservation/guest)}" />

}
</Hotel>
}
</system>



xml is like this:
<Hotel naam="hotelName">
<reservation ID="3" begin_date="2012-06-18" eind_date="2012-06-26">
<client ID="15" name="Axel Nieves" >
<room nr="E3E" kamertype="type 4">
<guest ID="404" naam="Florence Flores" />
<guest ID="203" naam="Charde Ashley"/>
</room>
/client>
</reservation>
</Hotel>
Postnext
Ivan PedruzziSubject: count in xquery
Author: Ivan Pedruzzi
Date: 10 Jul 2012 03:36 PM

See if the following helps. Which XQuery processor are you running?


Ivan Pedruzzi
Stylus Studio Team


Input document
-----------------------------


<?xml version="1.0"?>
<Hotel name="hotelName">
<reservation ID="3" begin_date="2012-07-05" end_date="2012-07-06">
<client ID="15" name="Axel Nieves">
<room nr="E3E" kamertype="type 4">
<guest ID="404" naam="Florence Flores"/>
<guest ID="203" naam="Charde Ashley"/>
</room>
</client>
</reservation>
</Hotel>



Query
-----------------------------

xquery version "1.0";

<system>{
for $hotel in doc("doc.xml")//Hotel
let $hotelName := $hotel/@name
return
<Hotel Name="{ ($hotelName) }">
{
let $beginWeek := fn:current-date() - xs:dayTimeDuration(concat('P', 7, 'D'))
let $endWeek := fn:current-date() - xs:dayTimeDuration(concat('P', 1, 'D'))
for $beginDate in xs:date($hotel/reservation/@begin_date)
for $endDate in xs:date($hotel/reservation/@end_date)
where ($beginDate gt $beginWeek and $beginDate lt $endWeek)
and ($endDate gt $beginWeek and $endDate lt $endWeek)
return <day date="{ count($hotel/reservation/client/room/guest) }"/>
}
</Hotel>
}
</system>


Result
-----------------------------

<system>
<Hotel Name="hotelName">
<day date="2"/>
</Hotel>
</system>
Postnext
pattex007 ex007Subject: count in xquery
Author: pattex007 ex007
Date: 10 Jul 2012 04:04 PM
thanks for reply

it works for one reservation but if i add one more reservation i get something like this:


<system>
<Hotel Name="hotelName">
<day date="4"/>
<day date="4"/>
<day date="4"/>
<day date="4"/>
</Hotel>
</system>

i'm using Altova XMLSpy
Posttop
Ivan PedruzziSubject: count in xquery
Author: Ivan Pedruzzi
Date: 10 Jul 2012 04:43 PM
Originally Posted: 10 Jul 2012 04:34 PM
Sorry, this forum is reserved to Stylus Studio customers.

Ivan Pedruzzi
Stylus Studio Team
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.