[HippoCMS-dev] DASL Query ordering by caption gives wrongly ordered result

[Nick Stolwijk]

I am executing a DASL query [1] against the repository 1.2.15 to
select a number of results ordered by their caption. I get a number of
results [2] which are wrongly ordered. I have tried to throw away the
index at the repository and rebuild it, but that didn't help. What can
cause this behavior?

With regards,

Nick Stolwijk
~Java Developer~

Iprofs BV.
Claus Sluterweg 125
2012 WS Haarlem
www.iprofs.nl

[1]
<?xml version="1.0" encoding="utf-8" ?>
<!-- productlist_dasl.ftl -->
<d:searchrequest xmlns:s="http://jakarta.apache.org/slide/";
xmlns:h="http://hippo.nl/cms/1.0"; xmlns:d="DAV:">
    <d:basicsearch>
        <d:select>
            <d:prop>
                <s:nrHits/>
                <d:displayname/>
                <h:caption />

            </d:prop>
        </d:select>
        <d:from>
            <d:scope>
                <d:href>content</d:href>
                <d:depth>Infinity</d:depth>
            </d:scope>
        </d:from>

        <limit xmlns="DAV:">
             <nresults>12</nresults>
             <offset xmlns="http://jakarta.apache.org/slide/";>0</offset>
        </limit>

        <d:orderby>
            <d:order>
                    <d:prop>
                        <h:caption/>
                    </d:prop>
                    <d:ascending />
            </d:order>
        </d:orderby>
    </d:basicsearch>
</d:searchrequest>


[2]

<?xml version="1.0" encoding="UTF-8"?>
<D:multistatus xmlns:D="DAV:">
    <D:response>
        <D:href>/default/files/default.www/content/aaaa-buiten.xml</D:href>
        <D:propstat>
            <D:prop>
                <S:nrHits
xmlns:S="http://jakarta.apache.org/slide/";>4</S:nrHits>
                <D:displayname>aaaa-buiten.xml</D:displayname>
                <caption xmlns="http://hippo.nl/cms/1.0";>AAAA - buiten</caption>
            </D:prop>
            <D:status>HTTP/1.1 200 OK</D:status>
        </D:propstat>
    </D:response>
    <D:response>
        <D:href>/default/files/default.www/content/dominicus.xml</D:href>
        <D:propstat>
            <D:prop>
                <S:nrHits
xmlns:S="http://jakarta.apache.org/slide/";>4</S:nrHits>
                <D:displayname>slovenie-istrie-rg-dominicus.xml</D:displayname>
                <caption xmlns="http://hippo.nl/cms/1.0";>DOMINICUS</caption>
            </D:prop>
            <D:status>HTTP/1.1 200 OK</D:status>
        </D:propstat>
    </D:response>
    <D:response>
        
<D:href>/default/files/default.www/content/appdata/webwinkel/categorien/reis-en-cadeauartikelen/reisartikelen/aaaa-leden.xml</D:href>
        <D:propstat>
            <D:prop>
                <S:nrHits
xmlns:S="http://jakarta.apache.org/slide/";>4</S:nrHits>

<D:displayname>anwb-werelstekker-voordeel-voor-leden.xml</D:displayname>
                <caption xmlns="http://hippo.nl/cms/1.0";>AAAA leden</caption>
            </D:prop>
            <D:status>HTTP/1.1 200 OK</D:status>
        </D:propstat>
    </D:response>
    <D:response>
        <D:href>/default/files/default.www/content/zonnebril.xml</D:href>
        <D:propstat>
            <D:prop>
                <S:nrHits
xmlns:S="http://jakarta.apache.org/slide/";>4</S:nrHits>
                <D:displayname>zonnebril-202.xml</D:displayname>
                <caption xmlns="http://hippo.nl/cms/1.0";>ZONNEBRIL 202</caption>
            </D:prop>
            <D:status>HTTP/1.1 200 OK</D:status>
        </D:propstat>
    </D:response>
</D:multistatus>
********************************************
Hippocms-dev: Hippo CMS development public mailinglist

Searchable archives can be found at:
MarkMail: http://hippocms-dev.markmail.org
Nabble: http://www.nabble.com/Hippo-CMS-f26633.html