On Tue, Jan 7, 2014 at 11:29 AM, Ihe Onwuka <ihe.onw...@gmail.com> wrote:
> Tried that already but that will give me a let that follows a group by > which is not allowed so I put the return back. > > When I moved the count up before the group by (still with no return) to > counter that eXist gave me > > when I moved the let statement up before the group ........ > > err:XPDY0002 variable '$count' is not set. [at line 11, column > > > On Tue, Jan 7, 2014 at 11:20 AM, Michael Kay <m...@saxonica.com> wrote: > >> You need to cut out that middle "return". You've written two nested FLWOR >> expressions, and an "order by" clause on the inner FLWOR expression isn't >> going to affect the order of the outer FLWOR expression. >> >> Michael Kay >> Saxonica >> >> On 7 Jan 2014, at 10:47, Ihe Onwuka <ihe.onw...@gmail.com> wrote: >> >> xquery version "3.0"; >> The task is to display things in descending order of the number of times >> they occur. >> >> New Effort >> >> import module namespace sp="urn:xxxxxxxxxx.com" at 'common.xqm'; >> >> <counts>{ >> for $thing in >> subsequence(collection($sp:reviewsColl)/descendant::reviews[1]//thing,1,50000) >> group by $name:=$thing/@name >> return >> let $count:=count($thing) >> order by $count descending >> return <thing name="{$name}" count="{$count}" />} >> </counts> >> >> In New Effort, my post-grouping tuple should consist of the grouping key >> and a sequence of n $things where n is the number of of $thing for that >> grouping key. >> I aim to capture that in the let so that I can order by it when outputing. >> >> However the ordering does is ineffective and I get the same output as >> Original effort below which makes no attempt to order. >> >> Original Effort >> >> xquery version "3.0"; >> >> import module namespace sp="urn:xxxxxxxxxxxxxx.com" at 'common.xqm'; >> >> <counts>{ >> for $thing in >> subsequence(collection($sp:reviewsColl)/descendant::reviews[1]//thing,1,50000) >> group by $name:=$thing/@name >> >> return <thing name="{$name}" count="{count($thing)}" />} >> </counts> >> >> >> >> >> >> _______________________________________________ >> talk@x-query.com >> http://x-query.com/mailman/listinfo/talk >> >> >> >> _______________________________________________ >> talk@x-query.com >> http://x-query.com/mailman/listinfo/talk >> > >
_______________________________________________ talk@x-query.com http://x-query.com/mailman/listinfo/talk