1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
(: insert-start :)
declare variable $input-context external;
(: insert-end :)
<result>
{
let $end_dates := $input-context//item_tuple/end_date
for $m in distinct-values(for $e in $end_dates
return month-from-date($e))
let $item := $input-context
//item_tuple[year-from-date(exactly-one(end_date)) = 1999
and month-from-date(exactly-one(end_date)) = $m]
order by $m
return
<monthly_result>
<month>{ $m }</month>
<item_count>{ count($item) }</item_count>
</monthly_result>
}
</result>
|