In the E10 BAQ designer, the query only wants to return 10,000 rows. So, it does this and then it says “Query has no more records to return.” (screenshot 1) I know there are more than 10,000 rows and why does it say this, erroneously? So then I try another run to get more data rows, typing in “Ro…

The limit works in baq designer itself only, not when query is executed. In case that such many rows were produced by mistake. If you need to see more than 10000 rows in baq designer, there is special execution flag to remove this limitation.

This is what Olga is referring to. [image]

Hi Ted and Olga, Thanks for tips on removing the row limit. However, I cannot seem to find a way to make this stick. I remove the row limit, set it to true, run query and then get all of my rows. I save the query. I close out of Epicor and come back in and the row limit is there again. Am I mi…

This row limitation is used inside BAQ designer only. It is done for protection, in case something went wrong during query design, like JOIN was not defined, or defined incorrectly, and unreasonable number of rows is returned by mistake. But when you save this query and run it from dashborad for e…

As per other replies, run the query in a dashboard to get the full results. Be careful though, there is an app server level setting which also restricts the number of rows that can be returned and also the timeout. If your query exceeds these parameters you may find that the dashboard simply retur…

When I tried using the special execution flag to remove this limitation (RemoveTestRowLimit), it still limits it to 50,000 returned row results. Is this a BAQ design limitation of 50,000 returned row results or can this be modified?

No BAQ does not have any hardcoded limitation. Only what you set in query itself or in web.config

In regard to getting RemoveTestRowLimit setting to stick after saving, have you checked ‘Persist in Query’ checkbox? This is how I remove the limitation in my BAQs. Once, you have done this there should be no more limitations on your data. I have BAQs that return several hundred thousands of reco…

Just put the BAQ into a dashboard. There isn’t a row limit there.

I agree with @Banderson … i would typically create a BAQ, then go to a dashboard and put it there, and get all the results.

BAQ Designer - rows to return

Epicor ERP 10

cchang (CChang) November 2, 2022, 3:16am 12

There is an appserver level setting that limits the BAQ results. This server setting overrides the BAQ’s settings unless you do not have a max result setting at the server setting level.

BAQ/Quick Search, Only Retrieving 50 Records

Topic		Replies	Views
BAQ more thank 10k rows Epicor ERP 10 baq	1	3184	April 10, 2021
Query system limit of 10 result rows has been reached for the query Epicor ERP 10 baq	3	957	May 31, 2019
BAQ - 10,000 record limit Epicor ERP 10 e10 , epicor , baq	12	2567	October 20, 2023
BAQ/Quick Search, Only Retrieving 50 Records Kinetic ERP	11	1028	November 17, 2022
Dashboard 1000 row limitation Kinetic ERP	5	1222	June 10, 2024

BAQ Designer - rows to return

Related topics