Dashboard Filter (via Tracker pane) for Boolean field

Epicor ERP 10
3

Yes. My solution was to make a Calculated field that returned “YB” for true, and “NB” for false.

Then in my dashboard made tracker input on that calc field and a filter of “Starts With” (or Begins??). Then a customer can:

  • Put a Y in and get just the rows that the bit field is true.
  • Put an N in to get just the ones that are false.
  • Leave it blank to get either.

I originally had it so it would use a “CONTAINS” filter and you could enter B (for both). But ran into problems when a version upgrade of E10 broke the “contains” filter. So no I just leave it blank.

1 Like