Say I have a user table with a Yes/No column named Verified. If I want to search all verified users, just typing in verified in the search bar will show all verified users.
The current workaround is to add a searchable virtual column which will print “Verified” or “Not Verified” based on the value of the “Verified” column. The downsides are that I have to add a virtual column for each Yes/No searchable columns and all the virtual columns have to be shown because hidden columns cannot be searched.
It will be nice if we can assign searchable texts for Yes and No values for a Yes/No column.