How to count the number of assets in a Assets Object field

Question

I'm looking for a way to count the number of assets in an Asset Object reference custom field.   Since this is to be used in a Jira issue gadget in Confluence, it needs to be available via JQL.

I have an assets custom field "Affects Platform" and I need to be able to query for all issues that have at least 2 objects in that field.  Something like the snippet below but of course this finds issues with any number of objects in the field.

"Affects Platform" in aqlFunction("objecttype = Platform")

Chris Melville_iyijlg · Answer

Thanks Adolfo, I agree that would work.  I prefer not to create yet another custom field if I can avoid it but if there really is no other option I may take this approach.  I will wait a bit to see if there are any clever answers that don't require that.

Adolfo Casari · Answer

@Chris Melville  You should create a number customfield and have an automation rule that parses "Affects Platafform" customfield to check how many objects it has and then put that value in your customfield.

Then you can use that customfield in JQL (.e. "customfield name" >= 2)