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; } } }

Ask how to use Lookup issues action

koutarou ishibashi

I would like to search for subordinate tickets using the Lookup issues action and calculate the number of issues with a status of DONE and the number of issues with a status other than done.

Is there a way to use {{lookupIssues}} to display the number with a status of done and the number with a status other than done?

Accepted answers

Bill Sheboy

Hi @koutarou ishibashi

You may use multiple Lookup Issues action calls, with different JQL; or use one call, and list iterators, smart value, list filtering and math expressions to do that:

For some examples...

To get the count of the Done issues, that would be this:

{{#=}}0{{#lookupIssues}}{{#if(equals(status.statusCategory.name,"Done"))}}+1{{/}}{{/}}{{/}}

That works by iterating over the lookup, filtering by status category, adding 1 for each issue found, adding a default value of 0, and summing the results.

To find the not-done ones, wrap the equals() condition with not().

Kind regards,
Bill

All comments

John Funk

Hi Koutarou,

Yes, you should be able to do that.

Create your rule and add your lookupIssues action. Add your JQL that identifies the Done ones.

Then you can create a variable if you want to go that route which would be the variable name and this code: {{lookupIssues.size|0}}

Then you use the variable name for updating a field, or include in an email, etc.

koutarou ishibashi

I would like to search once as below.
"Parent Link" = {{issue.key}}

Is it possible to identify them using {{lookupIssues}}?

John Funk

Yes, it would look something like this:

koutarou ishibashi

Is it possible to search using only the search below?
"Parent Link" = {{issue.key}}

I would like to search only once and use {{lookupIssues}}.
I would like to know how to use the following correctly.

Bill Sheboy

Hi @koutarou ishibashi

You may use multiple Lookup Issues action calls, with different JQL; or use one call, and list iterators, smart value, list filtering and math expressions to do that:

For some examples...

To get the count of the Done issues, that would be this:

{{#=}}0{{#lookupIssues}}{{#if(equals(status.statusCategory.name,"Done"))}}+1{{/}}{{/}}{{/}}

That works by iterating over the lookup, filtering by status category, adding 1 for each issue found, adding a default value of 0, and summing the results.

To find the not-done ones, wrap the equals() condition with not().

Kind regards,
Bill

koutarou ishibashi

Thank you for your reply. It was very helpful.

By the way, I would like you to let me know, but I am having trouble searching for dropdown fields that have dropdowns A, B, and C using the method below.
How can I search for a dropdown field?

{{#=}}0{{#lookupIssues}}{{#if(equals(customfield_10209,"A"))}}+1{{/}}{{/}}{{/}}

Bill Sheboy

For a selection field, there is a value attribute, such as this:

To confirm you have the correct expression for the counting, please answer:

Is your custom field single selection or multiple selection?

Are you trying to find issues where one of A, B, or C are selected, or all values A, B, and C are selected?

koutarou ishibashi

The field is a single selection. This is a question in which one of ABC is selected.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation