Creation of Filter through Query Expression

(0) Share

Report

Posted on by Community Member

Hello Everyone,

I'm using a Query Expression to filter some data, and I can't figure out how to make them case insensitive.

To explain this better I'll give you the following example

I get a string with keywords like this "MySQL Oracle". Currently I'm verifying the string by Operation.Similar condition.

But suppose if the search string starts with smaller case and the actual entry is in upper case then the above doesn't work since it's case sensitive.

I'm trying to make them case insensitive, That way I'll find the words that are not specifically written with the upper/lower cases.

So basically I need to know how to get all the results that contain the upper or lower case from the given words.

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report
Hi,

You can used ConditionalOperator.Like. But you need to remember, you need to put % also because this is like:

var query = new QueryExpression(Contact.EntityLogicalName) { ColumnSet = new ColumnSet(true), NoLock = true, }; query.Criteria.AddCondition("fullname", ConditionOperator.Like, "%temmy%");

Hope this help!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Temmy,

I have a dynamic listof field name which is all in different case and the search entity through which I am searching can be in any case.

I'll explain with your example like I've many names in different case in fullname field and search name would be also in any case like "Temmy","temmy","TEmmy","temmY"etc. so for all search it should works.

Was this reply helpful? Yes No
Nithya Gopinath 17,078 on at

Like (0)

Report

Hi Ankur,

Refer the link below.

microsoft.public.crm.developer.narkive.com/.../case-insensitive-queryexpression

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Arun Vinoth 11,615 Moderator on at

Like (0)

Report

In that case, create another hidden field to store all uppercase or all lowercase equivalent of full name value (maintain the sync on create/update)

For ex. Full name “John Doe” will be stored as “JOHN DOE” in hidden field. Hence Query expression filter can be built like below:

query.Criteria.AddCondition("new_customfullname", ConditionOperator.Like, "%" + value.ToUpper() + "%");

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

If you are using a Condition in the QueryExpression, then the sort order of the organisation database will determine if the query is case-sensitive or not. You can specify the sort order when the organisation database is created, but you can't change the sort order after this

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Bad idea. "temmyABCDE" also fits this filter

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

After the request, you need to filter, for example Equals (result_string, StringComparison.InvariantCultureIgnoreCase)

Was this reply helpful? Yes No