Jira Assets Counting Field

Tim Patrick

Random requirement from a customer.

Imagine you have a box with a unique ID as an object, and books which all have unique IDs as objects. You then have 3 books in that box which are all linked through the attributes associations.

Can a field on the box object be set up to count how many books have been linked to that box?

Thanks

Jeroen Poismans

Hi Tim,

That is possible. The approach however would be different depending on how the link is made. If the box has an attribute  books, which contains the book objects, you could easily make an automation rule that looks like this:

• Trigger on object update
• Condition if objecttype = Box
• Lookup Objects linked to the box via AQL
  • Use the outboundReferences("") function

  • object having inboundReferences(objecttype = "Box" AND key = {{object.key}})

  • The lookup will return {{lookupObjects}} smartvalue (List)
  • {{lookupObjects.size}} will give you the number of linked books
• Use this smartvalue to updat the Asset via teh appropriate action to set the count attribute field.

More on smart values:
https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/

For the correct AQL you might want to use Reference Functions:
https://support.atlassian.com/assets/docs/use-assets-query-language-aql/#Reference-functions

Jeroen