BAQ Query Criteria using ANDs / OR and multiple parentheses

Epicor ERP 10
1

i am trying to create the subquery criteria in a BAQ for the following in SQL:
((por.PromiseDt is not null and por.PromiseDt <= cast(dateadd(month, 1, getdate()) AS date)) OR
(por.DueDate is not null and por.DueDate <= cast(dateadd(month, 1, getdate()) AS date)))

As you can see I have essentially ((A and B) OR (C and D)). How do I represent the outermost parentheses in the BAQ? I cannot create a criteria line for just a ( or ) without a table and field. See below:

image
image1453×995 69.6 KB

2

I know it’s a dropdown, but you can hand-type multiple parentheses.

image
image869×69 3.04 KB

1 Like
3

I think you can have more than one Parenthesis in those fields.

4

Thanks Jason!

5

If you don’t mind being a hack, you can actually add more than just parenthesis in those fields!
(as long as it creates a valid SQL statement)