Baq field filtered on bit/checkbox open orders only

Epicor ERP 10
1

Beginner…

I’m attempting to filter OrderDtl_OpenLine to only pull records of orders that are open. This field is a checkbox. I’ve made several attempts to try different filter values to no avail. I either get Open AND Closed or I get nothing.

2

Hi Lori, can you show your screenshots of your BAQ phrase builder with the table criteria on the OrderDtl table? It probably has to do with your logic or your table join

3

Hi Lori, set criteria of OpenLine = True

4

That was so easy and I was making it difficult. Thank you afabian!

5

If you do eventually want to filter on a bit field, I’ve found you need to add a calculated field to transform the bit into a Yes/No string value. Then you can filter using that to include true, false or both fairly easily. Dashboards don’t really do bit filtering well directly.

6

I’m pretty sure it will work with OpenLine = 1 too. Or 0 for false

1 Like
7

I was able to make it work, per Aeron’s post:
Go to Table Criteria > Select Field > Operation equals “=”, Filter Value / Constant = “True”
Thank you all for your responses. I’ve made notes of the other suggestions for future use.