How to filter assets to find objects without linked work items

Question

I want to delete Asset objects that fit certain criteria. One of them is they should not be used on Jira work items.

I have not found a way to filter them or use Advanced AQL to make sure they are not being used in a work item.

I need to do this filtering in Assets because I want to use the bulk delete option.

Looking forward to any suggestions!

Lacy Saute · Accepted Answer

Hi @A_ Boehme _Communardo_! You can use object not having connectedTickets()

This function is referenced in this documentation: https://support.atlassian.com/assets/docs/use-assets-query-language-aql/