In dashboard i am facing one issue i.e filter is not working for case sensitive letters. If a chart consist some letters in lowercase and when i enter uppercase letters in filter then chart returning error.
But same thing i can achieve in chart made by sql query and adding variable filter in query.
As you can see in picture when i put celo in lowercase then the filter is working for all charts(charts made with both query builder and using sql query)
but when i enter CELO in capital letters then filter is not working for chart which is made up using query builder as you can see in second picture
what is the solution for this to filter case sensitive letter for those charts which made using query builder