Error: Ad-hoc query could not be deleted. This ad-hoc query or a selection created from this ad-hoc query may be in use- when deleting a query after merging a query

After creating two new queries, and merging into one, you may receive the message, "Error: Ad-hoc query could not be deleted. This ad-hoc query or a selection created from this ad-hoc query may be in use." This message can occur even after deleting the merged query and if the original queries were not marked as selections.
Although we can not delete the query, we can avoid it from being used with the following steps:
  1. Navigate to Analysis>Information Library
  2. Click Manage Folders
  3. Add a new query folder name Inactive and Save
  4. Rename the query we want to delete to Inactive or Do Not Use
  5. Add the query to the Inactive folder to avoid it being used

Steps to Duplicate

  1. Navigate to Analysis>Information Library
  2. Create any two queries and save
  3. Click drop down next to either query and select Merge
  4. Select any merge filter, such as Either A or B
  5. Save new query
  6. Click drop down next to either original query and select Delete
  7. Receive error

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.