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
  • Aug 9, 2019

    Admin response

    This was shipped in Service Pack 21.

  • Attach files
  • Satya Atluri commented
    9 Aug, 2019 02:35pm

    YAY! Happy to note it is now in SP21.

  • Lori Thompson commented
    31 Jan, 2019 09:45pm

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

  • Lori Thompson commented
    31 Jan, 2019 09:45pm

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

  • Kristin Richardson commented
    31 Jan, 2019 08:14pm

    Make it happen.

  • Lorne Schneider commented
    28 Jan, 2019 07:18pm

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

    See attached file.

  • Stephanie Krebs commented
    24 Jan, 2019 03:13pm

    This is needed!

  • Rob Downs commented
    22 Jan, 2019 02:02pm

    This would be extremely helpful to us!

  • Deb Hanson commented
    21 Jan, 2019 02:47pm

    Yes!  I have been wanting this for years! 

  • Satya Atluri commented
    18 Jan, 2019 09:35pm

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

  • Erika Layfield commented
    18 Jan, 2019 06:30pm

    yes! please!

  • Jessie Rader commented
    18 Jan, 2019 06:04pm

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

  • Stephanie Boyce commented
    8 Jun, 2018 01:54pm

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

  • Guest commented
    17 Oct, 2017 01:32am

    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.

  • Breanne Olson commented
    28 Dec, 2016 03:26pm

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

  • Shannon Lee-Rutherford commented
    3 Feb, 2016 10:48pm

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

  • +159