On 21/11/2016 12:59, Adrian Gonzalez wrote:
Hello,
I'd like to execute a case insensitive search in Syncope.
i.e. querying all users with an attribute givenName that matches
'martin' would return :
Martin
martin
mArtin
Is there a way to do this with a Fiql search ?
i.e. something like UPPER(givenName) = UPPER('martin') ?
If no are there other ways to do this ?
If no, I can always store givenName attribute in 2 different
attributes (i.e. the real givenName attribute and a
givenNameCaseInsensitive attribute to store it in lowercase), but I
would like to avoid it if possible.
Hi Adrian,
I confirm that currently it is *not* possible to perform case
insensitive searches.
Nevertheless, it would be a nice feature to add: essentially, one should
be adding 'lowercase()' clauses to the native SQL queries manage by [1]:
the problem is that, as far as I can tell, such clauses are DBMS-dependent.
Would you mind creating an improvement on JIRA for this?
Naturally, contributions are welcome ;-)
Regards.
[1]
https://github.com/apache/syncope/blob/2_0_X/core/persistence-jpa/src/main/java/org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
