How to filter assets to find objects without linked work items

[A_ Boehme _Communardo_]

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 solution]

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/

[A_ Boehme _Communardo_]

Thanks so much! Worked like a charm. I didn't manage to find the right info in the documentation when I checked.

Thanks also to Shashank! I don't know what happened with your comment, but I got the notification.