Create a way to locate all | Ideas for Blackbaud CRM and BBIS

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

Blackbaud CRM / Query

Aug 9, 2019

Admin response

This was shipped in Service Pack 21.

Attach files

Enter a subject

Satya Atluri commented

August 09, 2019 14:35

YAY! Happy to note it is now in SP21.

×
Attachments Open full size
Lori Thompson commented

January 31, 2019 21:45

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

×
Attachments Open full size
Lori Thompson commented

January 31, 2019 21:45

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

×
Attachments Open full size
Kristin Richardson commented

January 31, 2019 20:14

Make it happen.

×
Attachments Open full size
Lorne Schneider commented

January 28, 2019 19:18

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

See attached file.

Object Referenc...

×
Attachments Open full size
Stephanie Krebs commented

January 24, 2019 15:13

This is needed!

×
Attachments Open full size
Rob Downs commented

January 22, 2019 14:02

This would be extremely helpful to us!

×
Attachments Open full size
Guest commented

January 21, 2019 14:47

Yes! I have been wanting this for years!

×
Attachments Open full size
Satya Atluri commented

January 18, 2019 21:35

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

×
Attachments Open full size
Erika Layfield commented

January 18, 2019 18:30

yes! please!

×
Attachments Open full size
Jessie Rader commented

January 18, 2019 18:04

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

×
Attachments Open full size
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.

×
Attachments Open full size
David Wanless 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.

×
Attachments Open full size
Guest commented

December 28, 2016 15:26

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

×
Attachments Open full size
Guest commented

February 03, 2016 22:48

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

×
Attachments Open full size