Calculate the Sum of custom field across projects

[anthony_butler]

Hi,

I have two projects, Incident Management and Problem Management. In the Incident Management project I have a field titled 'Total Agent Hours' that we fill in with a numeric value at the end of every incident to reflect how many hours it has cost us from an end user CS agent perspective. We then link our incidents to problem tickets in the Problem Management project. One problem can have multiple incidents linked to it if necessary. 

I would like to be able to set up a rule or automation that takes the 'Total Agent Hours' value from the incident tickets and returns a sum of them on the problem ticket. I would like this to update each time a new incident ticket is linked to the problem ticket so as to show a running total. For example:

Incident ticket 123 has a value of 10 agent hours, when it is linked to problem ticket 123 the value of 10 is shown in the agent hours field.

Incident ticket 345 has a value of 20 agent hours and is subsequently linked to problem ticket 123. The value in he agent hours field should now read 30. 

Is it possible to set this up using Project Automation? We do have scriptrunner installed, but this seems more complex to set up and I am the only one that can set these things up and I'm not good with scriptrunner! 

Many thanks for your help.

[William Crighton [CCC]]

@Jeremy Boles -

The software Atlassian uses to provide JIRA and Confluence as a SAAS application had to be implemented in a way that while still providing a method for enhancing the applications restricted what those enhancements could do. They did this via a combination technical things that I don't fully grok or understand well enough to elucidate upon much beyond where they will work.

While the Atlassian Cloud architecture does allow for type 2 plugins to be run (in the cloud application) these type 2 plugins represent a great deal of time and effort for Atlassian to support and validate every time there is another release for the Cloud. A very small number of select plugin vendors were asked to participate in the initial cloud offering with their type-2 plugins and those were the only plugins/addons available for Atlassian Cloud instances until the advent of Atlassian Connect which introduced type 3 Plugins and the marketing name change from Plugin to Addon.

Type 3 plugins are a very interesting solution to this problem and solve it primarily by 1) using advanced java programming techniques and 2) limiting the available API between the addon and the atlassian product. This is done by not hosting the addon on the same server as the Atlassian Application - type 3 plugins are hosted on an external server, and any data they display is data that has to be transported from the JIRA server through the externally hosted addon server and then back to the JIRA server or just straight to the client browser for display.

There - more accurate and so on, a little history - I think most of it is accurate but I might be missing a point here or there that someone can correct.

The big thing is that Atlassian Addons can be of type 2 and run directly in the Atlassian Cloud application, but third part, i.e. most all marketplace vendor addons, cannot as a type 2 addon. They must first be converted to a type 3 addon and an external hosting vendor engaged to host the addon prior to becoming available for use on atlassian cloud.

-wc

[Nic Brough -Adaptavist-]

All I have to add to that is that at the last Altas-camp last week, Atlassian made it clear Connect addons are what they are concentrating on. There's little to be added to the support for version 2 addons - they're not going away any time soon (as a lot of the core is written in them and they allow direct access to the full API), but they're not going to see any huge investment beyond keeping their framework working for what they do now. (As an aside, I suspect that means we'll see "Connect" added to Server versions sooner rather than later, but I'm just speculating now)

[Nic Brough -Adaptavist-]

No, that's not true.

Atlassian Cloud supports a limited list of type 2 addons (addons like Agile, Portfolio, JIRA Suite utilities, and so-on).  It also supports Connect addons

Atlassian Server versions allow you to install any type 2 addon you want.  Assuming you have full admin rights on it.

If you install on a hosted environment such as AWS, you will be running server versions, so you can help youself to type 2 addons, but not Connect ones (although that support is coming, as Atlassian are concentrating heavily on Connect over type 2)

[William Crighton [CCC]]

@Nic Brough [Adaptavist] - True, Atlassian can allow any type 2 addon to run on Atlassian Cloud - however, to the best of my knowledge they aren't doing this any longer. So to keep things simple I said that if Atlassian hosts the app then only type 3 plugins are allowed, which while not being 'absolutely true' is true enough for the guy asking the question who was smart enough to mention something about why type 2 plugins probably weren't allowed, which was accurate.

[Nic Brough -Adaptavist-]

That's still not right, type 2 addons are still running on Cloud. Agile is a type 2 addon for example. They are unlikely to add any more to the list of ones they will accept, unless there's some compelling reason to do so. Your (edited) answer went on to imply that the user would run Jira Cloud on AWS, and hence only have Connect addons usable, but I think that was just the way it was phrased and I was trying to clarify. I'm sure you meant to say that they'd have access to type 2 only (and you didn't mention Connect for server, which isn't available yet)

[William Crighton [CCC]]

@Nic Brough [Adaptavist] - yep, my answer was too fast and a little sloppy - thanks for the clarification. What's strange is that I didn't edit my answer....but now I will as it's totally without much value

[William Crighton [CCC]]

@Nic Brough [Adaptavist] - and seriously thanks for the comments, that point on your answer (or the first one at least) was from me.

[Nic Brough -Adaptavist-]

I do those a lot, and edit. All comments are welcome, especially when I'm wrong! It's usually versions of Jira/Confleunce/Agile that catch me out. Your last edit is great, it should be one of the FAQs that I'd like to see added to "Answers" so that we don't have to keep saying the same thing!

[Jeremy Boles]

Thanks for the answers. So in theory, we should be able to run any add-on if AWS hosted our instance of Jira that we would if we hosted it internally ourselves.

[Nic Brough -Adaptavist-]

Yes. (I like the nice short answers)

[Jeremy Boles]

Thank You, I assumed that was the case.