BAQ with DISTINCT?

I must be missing something somewhere, but in BAQ where do you set the option for DISTINCT ?
I want the query to look like;

SELECT DISTINCT 
field1
, field2 
FROM table .... 

Where in the BAQ UI is this option? Or if it isn’t then how would you go about achieving that? Would you hack away with GROUP BY? Tell me Epicor didn’t leave functionality this out. (version 10.2.400)

If you go to the SubQuery options tab under Query Builder, you may select distinct in the ‘Result Set Rows’ dropdown.

image

Great. I found Result Set Rows. I see that’s how you can set the TOP clause too.


This will be useful.