I have a problem, I need to check if the name exists using 'Contains' but I need to pass ToUpper or ToLower to ignore the case sensitive, I'm getting a failure saying it's not supported, any alternatives?
CODE:
ERROR:
If I do the query manually by 'Postman' directly in the API it works perfectly using:
contains(tolower(Nome) ,tolower('JOSE'))
I have a problem, I need to check if the name exists using 'Contains' but I need to pass ToUpper or ToLower to ignore the case sensitive, I'm getting a failure saying it's not supported, any alternatives?
CODE:![tipe](https://user-images.githubusercontent.com/51706758/221026607-7e3c6e83-d017-43ba-8426-44b432b94987.png)
ERROR:![falha](https://user-images.githubusercontent.com/51706758/221027043-a2113359-732e-4fe2-99f4-a47f4ee9a534.png)
If I do the query manually by 'Postman' directly in the API it works perfectly using: contains(tolower(Nome) ,tolower('JOSE'))
help