I’m trying to setup a filter on a QuickSearch with a True/False value but I cannot get it to work.
This is what the BAQ calculated field looks like
This is how the QuickSearch is setup
I have tried all variants of Upper and Lower case
How do I get it to work?
Thanks
Steve
This is a complete shot in the dark as I haven’t used quick search, but did you try 1 and 0 for your value? I have seen instances where true/false is interpreted as 1/0.
P.S. Also, true/false are keywords, not strings, so in your calculated field expression you do not enclose them in quotes.
This is (usually) the way.
Boolean true/false is normally stored as a bit, 1 or 0. But, “normal” is not a design requirement. Database design often gets punted to web devs and they make weird things instead of looking for what already exists. Booleans are at least fairly reliably stored as bit though, so 1/0 is a great place to start.
Date/time are a crapshoot though. Datatypes date and time and datetime and datetimeoffset exist but those values commonly get stored as string and decimal and int and etc. and that means you get to solve a little puzzle when you’re filtering or comparing.
*edit - not a dig at Epicor specifically. Commercial software and data standards are different universes. They look alike in a lot of ways but you can tell commercial software apart because it has a goatee.
