Automation rule for displaying blocked script count

[suvarna dixit]

I hv type of issue as a bug and lwd

Due to bugXyz..5 issues are blocked that linking has been done though linking Blocks 

I need count of those linking issues which are not done or cancel 

In above case script block count should 5 

[Trudy Claspill]

Hello @suvarna dixit 

You can get a list of issues that a blocking an issue and limit that to the issues that are not done with this query.

issue in linkedIssues("<issue key of Bug>", "blocks") and status not in (Done,Cancel)

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#linkedIssues--

In an Automation Rule you can use the Lookup Issues action to execute that JQL.

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues

After executing the Lookup Issues action you can get the count of issues found by that action using the smart value 

{{lookupIssues.size}}

[suvarna dixit]

There are more than150 bugs ,subquery is not working to check all the bugs 

[Trudy Claspill]

Please show us the automation rule you are using.

Are you looking for the issue linked to a list of bugs or the bugs linked to a list of issues?

[suvarna dixit]

[suvarna dixit]

If issues blocked by 4 diff issues out of 4 2 are from different projects then its not giving the correct count

[Trudy Claspill]

The Lookup Issues action will retrieve issues only from the projects you have specified in the Rule Details for the Scope of the rule. I see that your rule has a multiple projects scope. You will need to look at the details of the projects in scope and determine if projects are missing from the scope.