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

Have AuthorizableQueryManager Support Specifying Sort Ignore Case Mode

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.8.3
    • Fix Version/s: 2.9.1, 2.8.4
    • Component/s: jackrabbit-jcr-commons
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: