Dashboard Grid View Filter; field equals null?

Epicor ERP 10
, , ,
1

This seems so simple, but I can’t figure it out.

I have a dashboard with 2 grid views, each using the same BAQ. I’d like to filter one of the Views to include only specific entries in a custom field that is driven by User Codes. There are 6 possible string values in the field (blank is also possible), and I want the view to show only rows that contain one of 3 of those values.

When I set it up to include my desired entries, nothing shows in the Grid, which I assume is because it is looking for ALL of those to be true (AND instead of OR):
image

When I instead set the filter up to exclude the other values, I would also need to be able to filter out blanks. This is not a required field, and when no selection is made SQL shows the value = ’ ’ instead of is NULL.
image

Can anyone offer suggestions to help me accomplish this? Thank you in advance!

2

I found the answer in another thread:

Dashboard Grid Properties>Filter - ERP 10 - Epicor User Help Forum (epiusers.help)

Essentially, the best method is to create a calculated yes/no field in the BAQ that includes the multiple values you want to include in the grid view. Then in the dashboard, filter by the new calculated field.

I knew it was simple!

1 Like
3

Had you not had access to the BAQ to add the calculated field, I think changing that last filter condition to
OrderHed_OrderPriority_c > " "

Would have worked.