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

JQL query for counting the results obtained

Azahara Camacho

Hello,

I'm trying to generate a JQL query for automated project rules where the condition is:

-If all the tasks with a special label are in status "DONE", then change the status of another more relevant task.

For my condition, I need to check that the total of issues with status different to DONE is 0. However, I'm not able to generate that query where the total count is 0. Do you know any alternative or option to get that result?

Thanks a lot,

Azahara.

Accepted answers

Alex Koxaras -Relational-

Hi @Azahara Camacho ,

You can use within the automation the lookupissue component, as well as the smart value {{lookupissue.size}} to get the number (count) of the issues found that match the JQL on the lookup component

Screenshot 2021-04-27 155751.png

For example the above rule yield this result:

Screenshot 2021-04-27 155922.png

Hope that helps!

Cheers,
Alex

All comments

Alex Koxaras -Relational-

Hi @Azahara Camacho ,

You can use within the automation the lookupissue component, as well as the smart value {{lookupissue.size}} to get the number (count) of the issues found that match the JQL on the lookup component