nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SOLVED: How would you update an Asset object without going through a linked issue?

Derek Fields _RightStar_

Environment

Invoice Object Type with a "Total" field
Line Item Object Type with an "Amount" field and a reference to an Invoice Object

Problem

A user creates a new Line Item object. I want to increment the Total field on the referenced Invoice with the Amount on the Line Item. I do not want to have to go through a linked issue.

How would you implement this?

Accepted answers

Kris Dewachter

Hi @Derek Fields _RightStar_ ,

You could create an automation rule that is triggered upon the creation of a new Line Item object.

In the automation rule, you get all Line Items via an AQL statement, loop though the results and make a sum.

Best regards,

Kris

All comments

Kris Dewachter

Hi @Derek Fields _RightStar_ ,

You could create an automation rule that is triggered upon the creation of a new Line Item object.

In the automation rule, you get all Line Items via an AQL statement, loop though the results and make a sum.

Best regards,

Kris

Derek Fields _RightStar_

I will try that - thanks for the suggestion.

Derek Fields _RightStar_

@Kris Dewachter - Just a note that in order to make the summation work, I needed to join and split the Amounts in the list, like this:

{{lookupObjects.Amount.join(":").split(":").sum}}

I provide that in case you ever need to do something similar. Apparently, just using "sum" on the list doesn't work for reasons that I don't understand.

However, the problem that I really want to solve is to update an object that is not the object that triggered the rule. The only way I can see that I can update a referenced object attribute is to do it through an issue whether that object is referenced.

What would be ideal would be an Assets action that would take an Object Schema and Object Key (as a smart value) and let me update the attributes. However, that doesn't exist. I can only update the object that actually triggered the automation.

Any other ideas?

Kris Dewachter

Hi @Derek Fields _RightStar_ ,

Have you tried creating a AQL branch in the automation rule to get the object you need, and use the "Update Object" action in that branch?

Best regards,

Kris

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

automation

jira-service-management-cloud

jira-service-management

assets