Filters and case sensitivity question?

2530
3
Jump to solution
11-21-2014 02:00 PM
VenusScott
Occasional Contributor III

Is there a way to make the alpha characters in the filter widget to allow either upper or lower cases?

I'm finding that it's case sensitive and need it NOT to be.

0 Kudos
1 Solution

Accepted Solutions
RobertScheitlin__GISP
MVP Esteemed Contributor

Venus,

   They have not added that to their UI as something that can be configured. It is actually noted as an issue in the Beta 3 release notes. But you can work around this by manually editing the sql syntax in the config_Query,json.

Look for your "expr" attributes like this example:

"expr": "Crime_Type LIKE 'Drugs%'"

  and adjust it to this:

"expr": "Upper(Crime_Type) LIKE Upper('Drugs%')"

View solution in original post

3 Replies
RobertScheitlin__GISP
MVP Esteemed Contributor

Venus,

   They have not added that to their UI as something that can be configured. It is actually noted as an issue in the Beta 3 release notes. But you can work around this by manually editing the sql syntax in the config_Query,json.

Look for your "expr" attributes like this example:

"expr": "Crime_Type LIKE 'Drugs%'"

  and adjust it to this:

"expr": "Upper(Crime_Type) LIKE Upper('Drugs%')"

VenusScott
Occasional Contributor III

Thanks Robert!

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

Sure thing.

   Don't forget to mark the thread as answered by clicking on the "Correct Answer" button on the reply that answered your question.

0 Kudos