News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Quick Query Paging/Max...

Microsoft Dynamics SL (Archived)

Quick Query Paging/Max Rows

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I want my users to be able to use the Quick Query Viewer for project transactions, however I get 500,000 lines of results when I open the screen. I'd like to knock this down to around 10,000. According to the SL manual you can manipulate the maximum row count by adding this statement to the .ini file.

[QuickQuery]
Paging=Yes
MaxSQLRows=10000

I have tried updating my own .ini, to no avail. Is there a step I'm missing?

I'm on SL15 SP1.

Thanks in advance.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Quick Query Paging/Max Rows

Thank Bruce,

I changed the Paging to No in my .ini file and got the desired results.

[QuickQuery]

Paging=No

MaxSQLRows=10000
Verified answer

Bruce.T 405 on at

Like (0)

Report
RE: Quick Query Paging/Max Rows

Hi Jake,

The documentation I have (SL2015 CU2) says:

MaxSQLRows controls the number of rows per page when Paging is disabled - the default is 5000.

MaxTotalRows controls the rows returned when paging is enabled - as highlighted there is a discrepancy on whether the default is 500000 or 5000 - testing indicates that the default is 500000.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans