Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Quick Query View for A...
Microsoft Dynamics SL (Archived)

Quick Query View for Access Detail Rights is showing records duplicated many times over

(0) ShareShare
ReportReport
Posted on by Timothy Jones @Boyer 190

I have a large client that is working on their upgrade to SL 2011. We use the Quick Query view for "Access Rights Details". The issue is that this screen is incorrectly showing records duplicated many times over. For a sample user that should show 495 screens and reports, the Quick Query loads over 29,000 rows. The base view in SQL yields the same incorrect results. I have temporary added a "DISTINCT" clause to the SQL view, which fixes the issue, but this seems clearly to be a bug.

Is this issue already resolved in a Hot Fix for SL 2011?

The client is using SL version 8.01.211.08.01 specifically.

Thanks,

Tim

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Quick Query View for Access Detail Rights is showing records duplicated many times over

    Hi,

    Is there a Hotfix available for bug number 24188 yet? I cant seem to find one.

    Thanks,

    Waren

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Quick Query View for Access Detail Rights is showing records duplicated many times over

    Hello,

    I see that you also posted this issue to the partner forum as well.  This has been identified as a bug in the product and the bug number is 24188.  Thank you for bringing this to our attention.

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

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June 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)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans