web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    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.

  • Community Member Profile Picture
    Community Member on at

    Hi,

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

    Thanks,

    Waren

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans