Bill Sheboy Expert

Thanks, Jeff. I have observed JQL runs slower with negative conditions, so I wonder if you invert the status test to be positive what will happen to performance. For example: ... status IN (all possible other status values) ) or if I am interpreting your query correctly ...statusCategory = "In Progress" ) Also, what is the…

That is interesting... The documentation page indicates the retroactive adding of "done" issues to the version does not change scope, and that is what your chart shows. It seems a bit more vague on the impact to the "work completed" (light green sections), and your chart seems to indicate it plots them in their appropriate…

Yup, that should work. Think about edge cases for timing and cleanup when testing your rules. For example, when one of the rules does not fire due to some automation engine, timing, cloud infrastructure hiccup, etc. Perhaps consider adding a "magic value" to the label of that flag-task, helping you find them with a JQL…

I submitted a suggestion to make the smart value/automation documentation much more like the one for the REST APIs, with everything on one page, context indicators (by product: Cloud, Server/DataCenter, JSM, Admin), examples that can be downloaded and imported, and links to KB articles for known gotchas.

Hi @Brian Duimstra You may want to also post this question in the developer community to get more visibility on it: https://community.developer.atlassian.com/ I took a quick search in there and in the Atlassian Connect backlog and did not see this symptom noted. Kind regards, Bill

Hi @Chris Yukubousky From what you describe, you may want to use the if/else structure instead. That will create a block where to add your conditions and processing. When you want another block, just add another if/else...up to the 60 component limit per rule. For example: * trigger: issue created * if/else condition: add…

Hi @mat -- Welcome to the Atlassian Community! That email appears to be from a filter subscription in the specific Jira site noted in the email FROM address. However it is curious that the filter name in the email body appears blank, and I do not know what would cause that. Sadly there is no built-in way to find your…

Hi @Roman Lopez Basurto -- Welcome to the Atlassian Community! The cause of the multiple emails is that your scheduled trigger has JQL, and so the rule iterates over each of them. Please schedule the trigger without JQL, then use the needed JQL with your Lookup Issues. The result will be just one email with the requested…

Hi @steve.hough What have you tried thus far? If you have an automation rule you are trying, would you please post an image of it? For this use case, the two key differences between company-managed and team-managed (formerly called nextgen) projects are: * Company-managed link epic to children with "Epic Link" and…

Hi @Greg_Williams -- Welcome to the Atlassian Community! I do not believe that is possible with out-of-the-box JQL as it cannot perform a nested query. Instead you would need one of the marketplace addon apps to enhance JQL or a reporting addon that can filter parents and show all of their children, regardless of their…

Dawn, I suggest a next step is to work with your site admin to submit a ticket to Atlassian support for this symptom: https://support.atlassian.com/contact/#/ They can see logs that we cannot, and they may notice something we are missing on this problem. Perhaps included a link to this thread for reference of what has been…

Hi @jovanio_junior -- Welcome to the Atlassian Community! For a question like this please consider posting images of your complete rule and the audit log details. That may provide context for the community to offer suggestions. Thanks! If the trigger supplies issues and you want to use that information in your Create Issue…

Hi @Mela -- Welcome to the Atlassian Community! Yes, and...to what Jack suggests: Another limit to watch is the frequency/volume of rule execution. Even though you may not trigger more rules than your limit, you might run them too often per hour or too many hours runtime per day...which are other limits by license level.…

Hi @Harald Mayer As you note, Transfer User will help quite a bit, and it cannot find everything currently. Some additional actions to help are to use the rule export feature to find rules to update: * as site admin, export all of the automation rules to JSON from the global management area * determine the account ID for…

Hi @Robin -- Welcome to the Atlassian Community! I believe the version report is displaying correctly. Those issues were not in the version in the past, and were only added by you today. And, if there was a bulk-change ability for "history" then we could no longer rely upon it to be accurate. When you note that the release…

Rodney, have you checked that does what you need? That query would include anything created after March 16, 2022 at 8am, through Noon on March 16, 9999...and all the hours between. It would not return for the time range for each day in that date range. To perform such a query for multiple days you would need a marketplace…

Hi @rodney e That is not possible for all days, but it is possible for today...and if you save the filter and subscribe to a schedule you will get a daily email with the list. For your first query, it would be: project = myProjectName AND created >= startOfDay("+8h") AND created <= startOfDay("+12h") AND assignee =…

Thanks for that information, Jen. It appears there was a partial outage for Trello a couple of days ago when you posted this: https://trello.status.atlassian.com/ Have you seen the problem continue since then?

Well done!

Awesome! I am glad to learn that helped. Here are some good sources for smart values, their usage, and example rules. I also recommend following the automation product group in the community to watch for updates and new features in the articles. https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/…

Thanks, Jeff. The comparison of the JQL performance with defined values for key and reporter versus the dynamic lookups may not be equivalent. Would you please post the complete JQL used in that branch and an image of the branch component details in the rule? Also, would you please post an image of the audit log details…

Hi @Dawn Rodney Yes, and...to the questions Stefan and Jack asked: What type of project is this rule running against: company-managed or team-managed? Do you have any custom transitions in your workflow for the issues? If so, there is an open defect about custom event types not triggering a rule for a…

First thing: if your rule works with Jira Server with the email address for the mentions, keep using that. If not... Perhaps try this JQL in advanced search to see if the user's name will lookup and replace with the account ID, as it does with Jira Cloud: assignee = "enter the user name here" You may then use that account…

Hi, Michael. Thanks for the additional details as those help explain it. This is quite a complicated use case to implement in an automation rule, and it would be simple in a tool specifically meant to adjust scheduling. Anyway... First thing: will this use case ever encounter more than 100 issues in the chain? If so,…

Hi @Diego -- Welcome to the Atlassian Community! Yes, I agree...and...I expect over time that features that people find valuable in either company-managed or team-managed project boards/backlogs will even out some to become available in both. :^) Kind regards, Bill

Hi @Stefan Salzl There may be another way to do this with Server/Data Center that does not require the web request / REST API call is with delegation: * tell the parent to perform the check by adding a "hey do this" comment to the parent, and * use a second rule triggered on the comment (with "Allow Rule Trigger" enabled…

Hi Jim, When JQL does that search for the trigger, it is running against the issue history...and we do not have access to that in an automation rule (unless you call the REST API). Let's consider the simplest way to solve this: comparing the updated date to now. If we assume the last issue update was to the status, then…

Hi @Mayuresh Athalekar Here is an open suggestion to add that feature for Jira Cloud. I did not find an equivalent one for Jira Core Server, and you could add one. https://jira.atlassian.com/browse/JRACLOUD-70971 In this suggestion, it describes a work-around to do this with a saved filter and subscription which you may…

Hi @Jeff Gordon Very curious symptom... Why do you believe the JQL is executing in less than a second for that branch? How many issues is this rule trying to link, and is the number what you expected? Kind regards, Bill

Hi @Sneha -- Welcome to the Atlassian Community! Before building any comparison reporting in Jira, I respectfully suggest you have a conversation with your department manager to better understand what they mean by "over performing" and "under performing". That will save you some time not building the wrong solution, and…