Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Creating a Quick Query doesn't allow a filter to be applied

Posted on by 405

I am trying to add a filter to a new quick query - in the demos I have seen this is possible. However the filter button is not firing when I click on it. Is there a permission I am missing - note I am logged in with administration rights.

QQ-Filter-not-Available.JPG

Has anyone else encountered this and found a way to resolve?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Creating a Quick Query doesn't allow a filter to be applied

    Yes I have encountered this issue but only a new Filtered Queries that were saved without filters. Solution I found has 3 steps.

    Step 1: Open the Base Query first. This will allow the you to switch to any Filtered Query generated from the Base Query.

    Step 2: Switch to a Filtered Query that has filters and these filters can be modified (pretty much any other Filtered Query in the drop down list).

    Step 3: Switch to the Filtered Query that is having the issues. You can now add filters to this Filtered Query.

  • Bruce.T Profile Picture
    Bruce.T 405 on at
    RE: Creating a Quick Query doesn't allow a filter to be applied

    Thanks Charlene.

    I cant see anything in the current hotfixes for this issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Creating a Quick Query doesn't allow a filter to be applied

    There was an issue at one time that required you to be in as SYSADMIN, I that was regardless of rights.  There was a patch issued for it, don't remember if it was in CU2 or not, but might be worth looking for that issue specifically.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans