[jira] [Created] (SLING-3773) Drop order by clause in the query made for VanityPath

[Chetan Mehrotra (JIRA)]

Chetan Mehrotra created SLING-3773:
--------------------------------------

             Summary: Drop order by clause in the query made for VanityPath
                 Key: SLING-3773
                 URL: https://issues.apache.org/jira/browse/SLING-3773
             Project: Sling
          Issue Type: Improvement
          Components: ResourceResolver
    Affects Versions: Resource Resolver 1.1.0
            Reporter: Chetan Mehrotra
            Priority: Minor
             Fix For: Resource Resolver 1.1.2


Currently Resource Resolver's MapEntries uses following query for loading the 
VanityPaths

====
SELECT sling:vanityPath, sling:redirect, sling:redirectStatus FROM 
sling:VanityPath WHERE sling:vanityPath IS NOT NULL ORDER BY sling:vanityOrder 
DESC
====

It specifies the ORDER By for vanityOrder. However the code later does a custom 
sorting in MapEntry. So we can possibly drop the order by clause



--
This message was sent by Atlassian JIRA
(v6.2#6252)