Hi Jake,
On a side note, you sometimes want to pass result sets around, and process them
elsewhere, effectively forcing you to use braces like you mentioned. That would
still mess around your order. If the order is important enough, you can enforce
ordering by adding the nodes in order to a wrapper element, and select them
from there. It won't perform well with large sets, but I thought it might be
worth mentioning.
let $articles :=
( <article><dateline>2011-08-21</dateline></article>
, <article><dateline>2011-04-21</dateline></article>
, <article><dateline>2011-02-21</dateline></article>
, <article><dateline>2011-10-03</dateline></article>
, <article><dateline>2011-05-03</dateline></article>
, <article><dateline>2011-04-22</dateline></article>
)
return
(
<wrapper>{
for $art in $articles
order by xs:date($art/dateline) descending
return $art
}</wrapper>/*
)/dateline
Kind regards,
Geert
-----Oorspronkelijk bericht-----
Van: [email protected]
[mailto:[email protected]] Namens Ron Hitchens
Verzonden: woensdag 31 augustus 2011 21:38
Aan: General MarkLogic Developer Discussion
Onderwerp: Re: [MarkLogic Dev General] Inconsistent order returned by order by
clause
On Aug 31, 2011, at 8:16 PM, Michael Blakeley wrote:
> The final XPath step '.../dateline' reorders the results into node order, as
> specified by the W3C. A sequence of constructed nodes has indeterminate node
> order, so you will see unpredictable results. You can see similar behavior
> with sequences of attributes, which also have indeterminate node order. I
> would write '...return $art/dateline' instead.
>
> In passing, there's no need for the 'let-return-for-return' syntax. You can
> simply write 'let-for-return' and save some typing.
Or even just for-return:
for $art in
( <article><dateline>2011-08-21</dateline></article>,
<article><dateline>2011-04-21</dateline></article>,
<article><dateline>2011-02-21</dateline></article>,
<article><dateline>2011-10-03</dateline></article>,
<article><dateline>2011-05-03</dateline></article>,
<article><dateline>2011-04-22</dateline></article> )
order by xs:date($art/dateline) descending
return $art/dateline
=>
<dateline>2011-10-03</dateline>
<dateline>2011-08-21</dateline>
<dateline>2011-05-03</dateline>
<dateline>2011-04-22</dateline>
<dateline>2011-04-21</dateline>
<dateline>2011-02-21</dateline>
> On 31 Aug 2011, at 11:58 , Jake Trent wrote:
>
>> MarkLogic friends,
>>
>> When I run this script in CQ, why does the resulting order change every time
>> I run it?:
>>
>> let $articles :=
>> ( <article><dateline>2011-08-21</dateline></article>
>> , <article><dateline>2011-04-21</dateline></article>
>> , <article><dateline>2011-02-21</dateline></article>
>> , <article><dateline>2011-10-03</dateline></article>
>> , <article><dateline>2011-05-03</dateline></article>
>> , <article><dateline>2011-04-22</dateline></article>
>> )
>>
>> return
>> (for $art in $articles
>> order by xs:date($art/dateline) descending
>> return $art)/dateline
>>
>> If I remove the parenthesis from around the for clause, and return
>> $art/dateline, it's consistently ordered correctly:
>>
>> <dateline>2011-10-03</dateline>
>> <dateline>2011-08-21</dateline>
>> <dateline>2011-05-03</dateline>
>> <dateline>2011-04-22</dateline>
>> <dateline>2011-04-21</dateline>
>> <dateline>2011-02-21</dateline>
>>
>>
>> But if I return the top level element as a supposedly ordered sequence and
>> then return child elements off it, it seems like the articles aren't in
>> order at all:
>>
>> <dateline>2011-04-21</dateline>
>> <dateline>2011-08-21</dateline>
>> <dateline>2011-05-03</dateline>
>> <dateline>2011-02-21</dateline>
>> <dateline>2011-10-03</dateline>
>> <dateline>2011-04-22</dateline>
>>
>> Or
>>
>>
>> <dateline>2011-02-21</dateline>
>> <dateline>2011-05-03</dateline>
>> <dateline>2011-04-21</dateline>
>> <dateline>2011-08-21</dateline>
>> <dateline>2011-04-22</dateline>
>> <dateline>2011-10-03</dateline>
>>
>> Etc.
>>
>> I've gotta be missing some basic concept here. This doesn't seem right.
>>
>> Thanks for taking a look,
>> Jake
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://developer.marklogic.com/mailman/listinfo/general
>
> _______________________________________________
> General mailing list
> [email protected]
> http://developer.marklogic.com/mailman/listinfo/general
---
Ron Hitchens {mailto:[email protected]} Ronsoft Technologies
+44 7879 358 212 (voice) http://www.ronsoft.com
+1 707 924 3878 (fax) Bit Twiddling At Its Finest
"No amount of belief establishes any fact." -Unknown
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
