Using BAQ Designer, how to I select top 10 or distinct

Kinetic ERP
1

I do not see how to select top 10 or distinct when using the new BAQ Designer

1 Like
2

Select Subqueries from the Overflow, then Show Details, and the window that appears has the Options.

2 Likes
3

Alternatively, on the Run Query tab there’s a button for execution settings that looks like a gear. you can add a setting for QueryMaxResultSet that will limit your results.

image
image769×359 13.6 KB

2 Likes
4

Thank You very much,

5

Thank You,

This kind of trigger an additional question that may or may not be know, but can you pass Query Execution Setting or Top 10 request when getting a BAQ via Invoke-Rest process? I do a lot of passing ?Filters but was wondering in you can also pass execution or distinct arguments as well.

In advance, thank you for your assistance.

Rod

1 Like
6

The rest help page has a field for $Top when calling a BAQ as a GET, I don’t see any reason why you couldn’t use that to limit your results.

7

Thank You, I will give it a try and let you know how it turns out. It would be nice if it was able to help me fine tune these Extracts. We are SaaS and often need to extract EpiCor data and combine it with contract history from our previous ERP system and I use many Powershell scripts to do this. Once again, thank you.