Can I delete queries without affecting Collection Object

[aandroski]

Apologies if I missed this in the video portions of the documentation, but I’m having an issue with deleting queries. When I use 'Edit Query’ > ‘Delete,’ this message is returned: “Are you sure you want to permanently delete this Sp Query from the database? This action cannot be undone. This will permanently delete the following resource: SQL CollectionObject”

I am pretty sure I don’t want to delete CollectionObject, but I’m not sure how to get around that problem. Unfortunately, I amassed several rather useless queries while figuring out the Query Builder.

[Grant]

Hi @aandroski,

Thank you for reaching out!

You can safely click Delete and Specify will remove only the query being deleted, no Collection Objects. The dialog is a bit misleading, as the “SQL” icon before ‘CollectionObject’ is supposed to indicate that this is a query on the Collection Object table.

If you see the screenshot below, you can safely click Delete, and the query will be removed without affecting any Collection Object records:

[aandroski]

Good to know, and thank you so much for your fast response!