Jira Structure Formula Flag different fields

[Tim Petersen]

I'm setting up a Jira Structure that allows Teams in our Project to see what Issues they are assigned to are Blocking other Issues.

It'd be a Structure like this

Team

• Issue # 1 - Team: A
  • Issue # 2 - Team :B
  • Issue # 3 - Team : B

The initial Grouping is Team, and the relationship transformation is Is Blocking.

I'd Like to add a Custom Field, and I think Formula that showcases when the Parent Issue, in this case Issue #1, is Blocking another Teams Issue.

In the above use case, I would see an X or some symbol because Issue #1 is Blocking another Team.

Team

• Issue # 4 - Team: A
  • Issue # 5 - Team :A

In this use case, I wouldn't expect any Symbol to Flag as the related issues are owned by the Same Team

I've tried playing with  

issueFunction in issueFieldMatch('team')

but that just flags errors. 

Any suggestions?

[Stepan Kholodov _ALM Works_ · Accepted solution]

Hello @Tim Petersen 

You can try to use a formula like this:
if(count#strict{1} and team!=min#strict{team}, 'blocking')

the formula will be applied for all parent issues and it will return “blocking”(or anything else you want) for all issues that have sub-issues with different Team signed to them. 

I hope this helps. If you need further assistance with the formula or need help with anything else, please contact us directly at support.almworks.com and we’ll be back with you shortly.

Best regards,
Stepan Kholodov
ALM Works

[Tim Petersen]

That totally worked! Thank you!