Can I run a BAQ using consecutive parameters?

Epicor ERP 10
, ,
1

Hi everyone,
I have a very simple BAQ where I query the first four characters of the line description on an order and if they match a parameter, then return the sum DocUnitPrice.
This works very well, but at the moment I have a list of parameters in a dropdown list and have to execute each one individually.
Is there a way to set up the BAQ to run down a list of parameters, returning the results for each?
Thank you in advance
Adrian.

2

Calculated field for the first (4) characters of the description, filter BAQ for calculated field in a list of constants instead of parameters and group by your calculated field?

1 Like
3

Thanks Brian,
I tried your solution but I get the error below. Any ideas?
image

4

Try:

Substring(OrderDtl.LineDesc,1,4)
2 Likes
5

BAQs use T-SQL format and not C#

1 Like
6

Thanks guys, I have it working now. Sometimes it just needs someone else to look and spot the obvious error.
Thanks again
Adrian.