do case insensitive search using nxql

i'm using Nxql to do search on my custom document types, but i've noticed that with this NXQL query :

<fixedPart>
                ecm:isCheckedInVersion = 0 AND
                        ecm:mixinType != 'HiddenInNavigation' AND 
                        ecm:currentLifeCycleState != 'deleted' AND ecm:parentId = ? AND
                        ecm:primaryType = 'fiche_technique' 
          </fixedPart>

the search is case sentitive, i mean “work” and “Work” are not the same with this query , can you tell what should i add in order to have a case insentitive search ?

0 votes

1 answers

1492 views

ANSWER



hello,

you need to use the ILIKE operator to do case insensitive search.

Regards

0 votes