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.

[Alex Koxaras _Relational_ · Accepted solution]

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

For example the above rule yield this result:

Hope that helps!

Cheers,
Alex

[Azahara Camacho]

Thanks a lot @Alex Koxaras _Relational_ !! I didn't know that action and how to use it!
I think that it's enough for my problem! :)

[Alex Koxaras _Relational_]

Nice to know that this might suit your need!

[AP]

Had this exact question myself, thank you.

This use within lookupIssues is admittedly absent from https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/#--lookupIssues--, although this 'size' smart value is listed under comments & attachments.