AutoQuery Data Case-Insensitive?

Is there a way to make AutoQuery Data (not RDBMS) queries case insensitive?

There’s nothing customizable that changes the default behavior. What’s an example you’re trying to make case-insensitive?

I have a AutoQuery Service source that pulls data from Active Directory… Exact matches seem to be case-sensitive, i.e.

/users/windows/search?Email=foo.bar@foo.com won’t return a result if the user’s e-mail is Foo.Bar@foo.com

Using the Like Suffix seems to make it case-insensitive, but I’m worried about unintended consequences with that suffix.

1 Like

This is behaving as expected, = is an exact match whilst the %Like% ImplicitConvention is a CaseInsensitiveEqualCondition.

So you can choose to make case-sensitive or case-insensitive based on which convention is used.

2 Likes

That works for me, thanks!