Query system limit of 10 result rows has been reached for the query

Epicor ERP 10
1

I’m seeing something curious today. I have a query on live which I copied to test. All it has is APInvDtl filtered by invoice number 522019. On live it shows 88 rows, on test it shows 10 rows. I have Rows to return = blank, both queries are Type: TopLevel with ResultSetRows: All

Is there anything else that would limit the results? Am I in Demo mode?

image
image.png1790×658 93.5 KB

2

Have you tried running it with “Rows to Return” set to something like 100?

EDIT

Hmmm … I set a BAQ to 10, and the wording it uses is slightly different than what you see

image

3

In your application management console, click on Application Sever Settings.
What’s the setting in the BAQ Max Results Rows entry?

image

I did a test where I set that field value to 15 then I ran a query

image
This is the same message you got.

1 Like
4

Thanks for the help guys, that was it. It was set in the app server. Now to figure out who set it! That was annoying!