AnsweredAssumed Answered

Query ignoring case

Question asked by naresh on Sep 29, 2011
Latest reply on Oct 1, 2011 by naresh
I am trying to query an Alfresco repository for a document name ignoring case. What I have right now is this but it does not pick up documents that have "Debt" in their name (with upper case "D"):

    SELECT cmis:objectId FROM cmis:document WHERE cmis:name LIKE '%debt%'"

I understand that it is possible to do case insensitive queries using Alfresco extensions. How do I do that?

Thanks.
Naresh

Outcomes