So for a lookup table I have a column called active, it is bit data type. However when i set query builder it will show none of the records.
Bit type is mapped to boolean - you might need to use true instead 1.
Tried that too, but there was actually two locations where it was being invoked, you have the page and the form, when creating from crud, if you do it on both it broke the filter, Main by itself doesn't effect, and form invocation turned out to be the correct one.
Thank-you,