Hello guys,
I have this Xquery statement and I would like to do a group by date but unfortunately doesn't work well
Someone knows it? Any suggestion?
<TEST>
{
for $i in doc("transformXQUERY.xml")//TableID/TableRoom
let $A := $i/A
let $B := $i/B
let $cs-group := //TableID/TableRoom[Date eq $i/Date]
where exists($cs-group)
return
<TEST ID= "{$i/ID}" date="{$i/Date}" A="{sum($A)}" B="{sum($B)}"/>
}
</TEST>
I have this Xquery statement and I would like to do a group by date but unfortunately doesn't work well
Someone knows it? Any suggestion?
<TEST>
{
for $i in doc("transformXQUERY.xml")//TableID/TableRoom
let $A := $i/A
let $B := $i/B
let $cs-group := //TableID/TableRoom[Date eq $i/Date]
where exists($cs-group)
return
<TEST ID= "{$i/ID}" date="{$i/Date}" A="{sum($A)}" B="{sum($B)}"/>
}
</TEST>