Uploaded image for project: 'Jackrabbit Content Repository'
  1. Jackrabbit Content Repository
  2. JCR-3845

Have AuthorizableQueryManager Support Specifying Sort Ignore Case Mode

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.8.3
    • 2.9.1, 2.8.4
    • jackrabbit-jcr-commons
    • None

    Description

      Currently the AuthorizableQueryManager hard-sets to ignore the case for any specified sort property, resulting in a query that sorts like this:

       ... order by fn:lower-case(@myProperty) 

      this may lead to performance impact, as the lowercasing cannot be covered by a respective index.

      i therefore suggest to allow users of the AuthorizableQueryManager to specify whether lowercasing is desired or not, as an additional flag ignoreCase: true | false in the _ order | sort:_ section.

      anchela, kindly review attached patch.

      Attachments

        Activity

          People

            angela Angela Schreiber
            dominique.jaeggi Dominique Jäggi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: