Create a way to locate all instances of a query being used

When we try to delete a query from the database, sometimes we see the 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. There's no easy way to find where the query is being used so that it can be removed from those locations, and deleted. It would be helpful to have a way to search and locate all references to a query so that it can be deleted.
  • Guest
  • Jun 29 2015
  • Shipped
Organization Name (Please enter full organization name)
Reported Version
  • Aug 9, 2019

    Admin Response

    This was shipped in Service Pack 21.

  • Attach files
  • Shannon Lee-Rutherford commented
    February 03, 2016 22:48

    Love this idea - would greatly facilitate clean-up and organization of query files!

  • Breanne Olson commented
    December 28, 2016 15:26

    If this isn't already available, this would be great!

  • Guest commented
    October 17, 2017 01:32

    At the very least, this error message should be changed to tell us which other query (or other object) is using the query.  This information must be available as it is being checked.  It would be better to have a complete list, as otherwise we could be removing other references one by one for a long time, but at least the name of one other object would be a very good start.

  • Stephanie Boyce commented
    June 08, 2018 13:54

    This is really needed! Especially if you change major business processes and need to locate all queries using a certain field or selection. 

  • Jessie Rader commented
    January 18, 2019 18:04

    Yes! This would help us pair down the number of queries we have. 

  • Erika Layfield commented
    January 18, 2019 18:30

    yes! please!

  • Satya Atluri commented
    January 18, 2019 21:35

    It would be great to see this come in play after all these years. 

  • Deb Hanson commented
    January 21, 2019 14:47

    Yes!  I have been wanting this for years! 

  • Rob Downs commented
    January 22, 2019 14:02

    This would be extremely helpful to us!

  • Stephanie Krebs commented
    January 24, 2019 15:13

    This is needed!

  • Lorne Schneider commented
    January 28, 2019 19:18

    A couple of years ago I created a utility for just this purpose.

    See attached file.

  • Kristin Richardson commented
    January 31, 2019 20:14

    Make it happen.

  • Lori Thompson commented
    January 31, 2019 21:45

    This is really a critical issue for us.  Please review.  Thank you!

  • Lori Thompson commented
    January 31, 2019 21:45

    This is really a critical issue for us.  Please review.  Thank you!

  • Satya Atluri commented
    August 09, 2019 14:35

    YAY! Happy to note it is now in SP21.