Execute a BAQ with a list of paramenters

Epicor ERP 10
,
1

I have a behemoth of a BAQ that uses a CTE/Union recursive call to create a table. This query uses a part number as a “SubQuery Criteria” Parameter. I would like to run this using a list of parts with all the outputs of the BAQ in union (or summed together). Is this possible? I don’t mind using custom code as this only needs to execute once.

2022-08-04_10-51-21
2022-08-04_10-51-211920×971 95.1 KB

2

One of the parameter types is a list. You can add whatever you want into that list.

image
image1055×419 18.7 KB

image
image702×385 13.4 KB

4 Likes
3

And for the love of god, name your subqueries the next time!

2 Likes
4

Thanks for the information! I am getting the error Must ‘declare the scalar variable “@MoM_Part_Number”’ when I try to cast(@MoM_Part_Number as varchar(50)) I know this is wrong as I am trying to cast a list of varchars into a single varchar bucket however, I do not know how to fix it. Any ideas?

Thanks again,

5

Change your Criteria from “=” to “IN” When you do that you’ll be able to choose the list parameter that @Banderson had you create.

2 Likes