Microsoft Dynamics SL (Archived)

Quick Query - Delete Filtered Query View

(0) Share

Report

Posted on by Steve Wier

962

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ram Peru 2,830 on at

Like (1)

Report
Copy link

Link copied!
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

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

Was this reply helpful? Yes No
Steve Wier 962 on at

Like (0)

Report
Copy link

Link copied!

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

Thanks again!

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Steve Wier 962 on at

Like (0)

Report
Copy link

Link copied!

That works. Thank you!

Was this reply helpful? Yes No