Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Quick Query - Delete Filtered Query View

Posted on by 940

The instruction from the help for deleting a custom quick query view state:

To delete an existing filtered query view, follow these steps:

1. Open the Base Query View to which the Filtered Query View is related.

2. Use View Selection to select the Filtered Query View.

3. Click Delete.

4. Click Yes to confirm the deletion.

However, I cannot locate the "View Selection" option anywhere in the menu of the quick query screen: QQ.VIE.00

The delete option is only available on the main view, not the filtered view.  If I select it, it prompts System Message 12: Are you sure you want to delete?  Since I do not want to delete the main view, I have always selected No. 

Note: Logged into SL as SYSADMIN

How do I delete a filtered query view?

Thanks

Steve

*This post is locked for comments

  • Steve Wier Profile Picture
    Steve Wier 940 on at
    RE: Quick Query - Delete Filtered Query View

    That works.  Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Quick Query - Delete Filtered Query View

    Hi,

    You first have to select the original quick query view and open it.

    Then on the drop down menu on the Original Quick query view name, use that dorp down arrow to select your filtered view name, once it populates, you will then be able to delete the filtered view.

    Log out and log back it and then you will no longer see that filtered view.

    Gewen

  • Steve Wier Profile Picture
    Steve Wier 940 on at
    RE: Quick Query - Delete Filtered Query View

    Thank you for the detailed response.  I was hoping for something in the UI.  However, a quick SQL script will do.

    Thanks again!

    Steve

  • Suggested answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: Quick Query - Delete Filtered Query View

    Hello Steve,

    Good day to you.

    You can delete your filtered Query through SQL server Database if you have access to your SQL server. I’m explaining the steps with an example.

    • For instance, I have added the filtered quick query in standard Customer History
    • This QQ report is used Base SQL View QQ_arhist
      • Connect the SQL server
      • Go to your System Database
      • Execute the below query in your system Database
        • Select * from QVCatalog Where SQLView = 'QQ_Arhist'
      • This query will show you the standard QQ & Filtered custom Quick Query View

      QQ.PNG

      • Execute the below query in your system DB to delete your custom filtered QQ
        • Delete * from QVCatalog Where SQLView = 'QQ_Arhist'  and QueryViewName = 'FilterQQ_arhist'                                        
      • Here, QQ_Arhist is the Base SQL View & FilterQQ_arhist is custom filter query view name
      • You have to use your Base SQL view & custom filtered query view name in above delete query
      • You have to close and reopen the Dynamics SL after executing the query in your SQL server

      Hope this explains

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans