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.
YAY! Happy to note it is now in SP21.
This is really a critical issue for us. Please review. Thank you!
This is really a critical issue for us. Please review. Thank you!
Make it happen.
A couple of years ago I created a utility for just this purpose.
See attached file.
This is needed!
This would be extremely helpful to us!
Yes! I have been wanting this for years!
It would be great to see this come in play after all these years.
yes! please!
Yes! This would help us pair down the number of queries we have.
This is really needed! Especially if you change major business processes and need to locate all queries using a certain field or selection.
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.
If this isn't already available, this would be great!
Love this idea - would greatly facilitate clean-up and organization of query files!