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