do case insensitive search using nxql

ITShine_ — Tue, 18 Aug 2015 11:21:17 GMT

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 ?

Re: do case insensitive search using nxql

Thierry_Martins — Tue, 18 Aug 2015 11:58:04 GMT

hello,

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

Regards

topic do case insensitive search using nxql in Nuxeo Forum

do case insensitive search using nxql

Re: do case insensitive search using nxql