How can I compare the same field in multiple tickets to populate a field with the highest value?

[Kevin Petersen]

Hi everyone!

We have a product priority score model that I have required for every product requirement created.   We use a building block format (Building blocks are their own issue type) that houses system requirements to meet said product requirement.

For example:  Building Block 1 has system requirements a-z.    Multiple product requirements map to system requirements a-z.

The request is if a system requirement is mapping to multiple product requirements, how can I compare the score field from the multiple product requirements (A JIRA query) and populate the highest value on the system requirement in it's own field?

I know how to implement the automation around this using smart values, I just don't know how to get JIRA to do that comparison.  Is there anyway to do this without using scriptrunner as we don't have it?

[Matthew Knatz]

I don't think Jira will be able to do this without some help from a plugin.

My go-to for this kind of task is ScriptRunner, but since you don't want to/can't use that, your automation workaround is probably your best path forward.