Filter string - boolean

Hello,
I have a field in my datagrid, called "ativo!(upload://pRmwnRtNIvCRKr1ELKFsiPtR1WT.png)", where it is a boolean in the database, but I want when searching the filter it is not with the check button but with a string, causing it to return false always that this is different from "yes" and returns true only if it is equal to "yes".
It is giving an error because in the search filter by string and in the database it is boolean, I only need to use an if equal I mentioned above, but I do not know how.

Hi @SeaderGamer,

Changing the type of the field will not make string filtering work. The application relies on the database to perform the sorting which fails because comparing booleans with string won’t work. I am afraid this isn’t supported functionality.