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.
Solved! Go to Solution.
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%')"
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%')"
Thanks Robert!
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.