You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
I want to create an automation rule based on the number of issues in the specific column (perhaps, with the power of smart values or JQL).
Is there anyone who can help me with this issue?
Hello @Vitalii Iermolenko
Welcome to the community.
I don't think there is a way to identify the 'column' an issue is in via Automation.
The columns on boards are just a way to visualize the grouping of issues by Status. And an issue can appear on multiple boards in different columns (based on the mapping of Statuses to columns, per board).
You would need to instead look at creating automation based on the number of issues in the Statuses that are mapped to the specific column.
Yes, my mistake. I meant just count the number of issues with some status. And then use this number for automation rules, like if the number greater than X - send some message/email.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vitalii - Welcome to the Atlassian Community!
The board should already show you the number of cards in a column. What is it that you are trying to do with that number?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In that case, I would create a custom number field in Jira set the default to 0.
Then I would increment it by 1 each time an issue transitioned into that status using an Automation Rule. See the smart values and guidance here:
https://support.atlassian.com/jira-software-cloud/docs/use-smart-values-to-insert-numerical-values/
Then as each issue transitions out, I would have another rule that decreases the value by one
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you provide a little more information as to what you are wanting to do with the value once you get it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There isn't much information in your question that helps someone who wants to be helpful.
What do you want to trigger the automation?
What are the conditions that must apply for an issue to be in the column that you're interested in?
What is the goal of the automation rule?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I meant just count the number of issues with some status. And then use this number for automation rule, like if the number of issues with specific Status less/greater than X - send some message/email.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may not need to preserve the count to do this with an automation rule, particularly if your board is simple and the number of status values is smaller. Instead you could try:
However, if you are actively using your board this alerting may be unnecessary; you may just set the min/max WIP limits for a column (under Board Settings > Columns), and the board will highlight when outside of those boundaries.
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I believe Bill's JQL approach is probably what you're after.
Columns in a board are generally JQL based in some capacity as well. So writing a JQL filter for a specified project and status should be fairly straight forward. Then counting the number of issues found is a simple smart value. {{lookupIssues.size}}
Note that the lookup issues action will max out at 100 issues.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.