There’s currently no auto-delete of archived elements. The only options currently is either to manually do it or create an API request periodically, which deletes archived elements.
You cannot archive the personal collections - they are tied to the user.
I don’t understand what you mean about “in its place is a create SQL icon”. Where are you seeing that, can you provide steps-to-reproduce or a screenshot?
Can you please direct me how do delete archived items manually or by API request?
regarding your question, i am on the screen viewing items in my personal collection. I wanted to archive, really delete the entire collection as i am using this copy of the db to distribute to my customers (prod). Following instructions in users manual to archive a collection I searched on the top of the form , right side of teh blue band, and what i see is a rectangular icon with fly by message Write SQL. Here is where i would have expected option to archive the collectdion.
If you want to manually delete archived item, then it can be done by clicking the hamburger-menu (the three-line-icon), click “View the archive” (or go to the URL /archive), and click the trash-icon next to the archived item to remove it. Some items does not have a trash-icon and cannot be deleted.
As I said before, you cannot archive a personal collection, it’s tied to the user.
For non-personal collections, you click the pencil-icon () and click “Archive this collection”.
Anything in the blue top-bar are general controls, not related to the page you’re viewing.