Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / The New SP1 Quick Quer...
Microsoft Dynamics SL (Archived)

The New SP1 Quick Query Paging Feature Seems to be Generating Invalid Results

(0) ShareShare
ReportReport
Posted on by Butch Adams 4,763

Our client has been avoiding the use of QQ for some proven queries that they suddenly lost confidence in this week. (They are trying to close the month)

After some deep inspection tryng to reproduce the problems they reported, I find that when QQ is in the new paging mode and a filter is added, what returns is not the expected results.

In our case the QQ returns 76,000 records with no filters. When we add a filter to return just one of the three companies, we still have 76,000 records. When we examine the company column, every one of the rows has the name of the filtered company in it as if the filter did it's job. However, there should only be 45,000 rows in the result.

Add to the fun by exporting this result set into Excel and 76,000 rows export.

I went into solomon.ini and removed the paging feature and set the Max records parameter to 100,000 and the QQ screen started returning the expected results. I suspect the new paging feature is the culprit here.

Has anyone else seen anything like this?

*This post is locked for comments

  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at
    Re: The New SP1 Quick Query Paging Feature Seems to be Generating Invalid Results

    Hi Butch,

    I'm unable to repro this issue.  My QQVIE00.exe is version 8.01.30703.00  Every time I added/removed/re-added filters the row count updates properly.

    I'm sorry for the late reply.

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at
    Re: The New SP1 Quick Query Paging Feature Seems to be Generating Invalid Results

    Hi Adam,

    Yes, you describe exactly what happens. We discovered it on a custom QQ, but the view has GLTran at the center so I tested "Journal Transactions" and got the same results.

    With further testing, I noticed that adding a second filter causes the result set to start returning the correct number of records.

    For instance,  "Journal Transactions" opens with 77,863 rows.

    Add filter "Journal Type is AP" and hit TAB - 77,863 records and all of them have "AP in the JournalType column.

    Add filter "Transaction Type is AD" - 500 records. Exactly what "select * from GLTran where JrnlType = 'AP' and TranType ='AD'" returns

    Click the X on the second filter - 36,774 rows. Exactly what "select * from GLTran where JrnlType = 'AP'" returns.

    Click the first X and readd the filter  "Journal Type is AP" and hit TAB - 77,863 records and all of them have "AP in the JournalType column.

    This is reproducable in both my test and my prod environments.

    This is the solomon.ini section:

    [QuickQuery]

    Paging=Yes

    MaxSQLRows=1000

  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at
    Re: The New SP1 Quick Query Paging Feature Seems to be Generating Invalid Results

    Hi Butch,

    We do have a recent bug regarding the paging setting but it doesn't sound to be exactly related:  "Quick Query Grid to Excel produces extra records with pagination on"

    It sounds to me like you're seeing Quick Query bringing back all records and replacing the company ID with just one of 3 companies.

    Which specific query are you running?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans