BAQ/Dashboard Help - Search and return distinct rows

Epicor ERP 10
, , ,
1

I am making a dashboard for some inventory purposes and ran into something that is bugging me.
We want to allow our floor workers to be able to search for Material Locations based on either the Material Part Number or the JobNum.

Is there a way for me to be able to search by a Part Number and return the distinct rows (ignoring the JobNum Field), while still allowing the option to search by JobNum?

Another way of putting it is I want JobNum as a field in my (BA)query so I can search by it but I also want JobNum ignored if I search by Part Material, so I get a more readable output. (1-2 rows instead of ~50).

Example: Distinct Rows because of different Job Numbers, ideally these would all show up as just one row as they are all pointing to the same Bin/Lot

image
image1226×606 33.2 KB

Any ideas? I know I could always just make two separate dashboards, or two different queries and grids in the same Dashboard, but seeing if this could be accomplished in one.

Thanks,
Alec M.

2

Break it into two separate BAQs. and have your Dashboard have two panes, with the first BAQ not including the Jobnum, so it would consolidate the rows.