Case sensitivity in search forms

MelT

Hi everyone,

I want to make search forms without having problems with case sensitivity. Any ideas on how to do it in DQL ?

My query in my form looks like this :

"SELECT user_name , user_login_name FROM dm_user WHERE user_name like '$name$%'"

and when I search for a user, let's say Anthony, and if I type ant, it doesn't return me any results. With Ant, it returns me Anthony.

Thanks in advance for your help.

Mel

christopher.imes

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility.  Questions written to the users' own "Discussions" space don't get the same amount of attention and questions can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right.  Then search for and select: "Documentum" (Developer Network) which would be the most relevant for this question.

Seeing though that over 3 months have elapsed since you posted, maybe you have already found the answer (possibly opened up a ticket with support)?  If so, once relocated, consider sharing the resolution and also marking the question as "Answered" so that it can help others that have the same question.  If not, once relocated, it will then have more visibility by the community of dedicated customers, partners, and EMC employees that are eager to assist.