topic Re: Filters and case sensitivity question? in ArcGIS Web AppBuilder Questions

Filters and case sensitivity question?

VenusScott — Fri, 21 Nov 2014 22:00:53 GMT

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.

Re: Filters and case sensitivity question?

RobertScheitlin__GISP — Fri, 21 Nov 2014 22:31:24 GMT

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%')"

Re: Filters and case sensitivity question?

VenusScott — Fri, 21 Nov 2014 22:35:02 GMT

Thanks Robert!

Re: Filters and case sensitivity question?

RobertScheitlin__GISP — Fri, 21 Nov 2014 22:38:16 GMT

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.