Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.8.3
-
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.