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

**URL:** <https://www.epiusers.help/t/query-system-limit-of-10-result-rows-has-been-reached-for-the-query/56335>\
**Category:** Epicor ERP 10\
**Tags:** baq\
**Created:** [May 31, 2019, 5:50pm UTC](https://www.epiusers.help/t/query-system-limit-of-10-result-rows-has-been-reached-for-the-query/56335 "2019-05-31T17:50:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\
**Post date:** [May 31, 2019, 5:50pm UTC](https://www.epiusers.help/t/query-system-limit-of-10-result-rows-has-been-reached-for-the-query/56335/1 "2019-05-31T17:50:07Z")

</div>

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](https://epiusers.help/uploads/default/original/3X/c/f/cf33321a0f7e84a129e3a0ec2047739b26d05325.png)

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [May 31, 2019, 6:36pm UTC](https://www.epiusers.help/t/query-system-limit-of-10-result-rows-has-been-reached-for-the-query/56335/2 "2019-05-31T18:36:51Z")

</div>

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](https://epiusers.help/uploads/default/original/3X/0/d/0d245b37971fdec540c8974cc023321a138c9634.png)

---

<div class="post-metadata">

**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\
**Post date:** [May 31, 2019, 6:47pm UTC](https://www.epiusers.help/t/query-system-limit-of-10-result-rows-has-been-reached-for-the-query/56335/3 "2019-05-31T18:47:39Z")

</div>

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

![image](https://epiusers.help/uploads/default/original/3X/a/0/a09837c5cb94a97f8f45e311a6a7f8edffc51f87.png)

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

![image](https://epiusers.help/uploads/default/original/3X/f/1/f107a060e1a6e76f0e0220a3dd14f9fba412e77a.png)  
This is the same message you got.

---

<div class="post-metadata">

**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\
**Post date:** [May 31, 2019, 9:47pm UTC](https://www.epiusers.help/t/query-system-limit-of-10-result-rows-has-been-reached-for-the-query/56335/4 "2019-05-31T21:47:47Z")

</div>

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!