Search code examples
aemaem-6aem-63

AEM 6.3 Query builder - How to search for case insensitive?

How can we make the query to ignore case sensitivity of the property.value ?

Our query:

path=/content/central-content/jcr:content/main/decline_letter
property.value=0091A
property=@letterNumber
type=nt:unstructured

Works for 0091A but fails for 0091a

Solution

  • Using fulltext seemed to be helping/working.

    path=/content/central-content/jcr:content/main/decline_letter
fulltext=0091A
property=@letterNumber
type=nt:unstructured
orderby.case=ignore

    fulltext may not be a good solution is we have to be searching among a lot of nodes/data. In our case, we search for a very minimal number of nodes.