Skip to main content
12-Amethyst
March 5, 2019
Question

Query-Objects case insensitive

  • March 5, 2019
  • 1 reply
  • 1397 views

Hello,

I need to make the query-object search case insensitive. According to the documentation, it is by default. But it my test it does not work. So I put the explicit parameter

 

<ie:param name="WHERE_CASE_SENSITIVITY" data="FALSE"/> 

but the case still sensitive.

Is there further parameters or changes needed?

 

Thank you.

1 reply

18-Opal
March 9, 2019
Your webject syntax looks fine.

Did you try writing a QuerySpec? When you add a SearchCondition to a QuerySpec using the appendWhere() method you can add an additional boolean parameter on the end.
true = case sensitive, false = case insensitive.

Iโ€™ve used this many times and itโ€™s always worked as advertised.
rzemmali12-AmethystAuthor
12-Amethyst
March 11, 2019

The issue was related to another functionnality. Now it works.

Thanks anyway.