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
    18 Jan 18:04

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

  • Erika Layfield commented
    18 Jan 18:30

    yes! please!

  • Satya Atluri commented
    18 Jan 21:35

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

  • Deb Hanson commented
    21 Jan 14:47

    Yes!  I have been wanting this for years! 

  • Rob Downs commented
    22 Jan 14:02

    This would be extremely helpful to us!

  • Stephanie Krebs commented
    24 Jan 15:13

    This is needed!

  • Lorne Schneider commented
    28 Jan 19:18

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

    See attached file.

  • Kristin Richardson commented
    31 Jan 20:14

    Make it happen.

  • Lori Thompson commented
    31 Jan 21:45

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

  • Lori Thompson commented
    31 Jan 21:45

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

  • Satya Atluri commented
    09 Aug 14:35

    YAY! Happy to note it is now in SP21.