Bill Sheboy Expert

Hi @Nivi Mor -- Welcome to the Atlassian Community! That does not appear to be possible yet for Cloud. There are a couple of open suggestions for this, including one to do this via automation rules. * https://jira.atlassian.com/browse/JRACLOUD-71328 * https://jira.atlassian.com/browse/API-65 However, I wonder if this would…

Hi @a.savchyn -- Welcome to the Atlassian Community! You cannot perform a query like that with out-of-the-box Jira Cloud's JQL. Instead you could: * Use a marketplace addon to enhance JQL, allowing such query types * Create a query for issues in the sprint, export your issues to gather the linked issue keys, build a CSV…

Hi @Mehmet A _Bloompeak_ Thanks for that link! Doesn't that method return all labels for the instance, not just for a specific project? Kind regards, Bill

Thanks for posting the video, @Christine P. Dela Rosa and thanks for your thoughts and answers to the questions. Ashley and Kelly!

Hi @John Worrall Interesting: I didn't even know that was an option until I saw your post and checked the help page. I tried it and I cannot see the option for a company-managed project. You appear to be the site admin for a paid license, so you should be able to create a support ticket…

Douglas, you cannot query with lookup issues that way. How about this: Let me try to draft a rule for what I believe you are doing, and you can provide ideas to improve it. * trigger: issue type changes * condition: issue type is your Task 1 type * branch: for the sub-tasks* condition: issue-type is not one of the valid…

Hi @John Tucci Yes, and...to what Trudy suggests: I added this suggestion a while ago to support column collapse/expand for boards. Please watch it if you want to learn about any progress on this. https://jira.atlassian.com/browse/JSWCLOUD-17698 Kind regards, Bill

Hi, Doug! I believe what you ask is possible with list functions and the list filtering capability: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588 With that, you probably can pull out the keys by type into a created variable, and then use that for your dependency list and…

Hi, Jon. Seconding Nic's follow-up, as I was trying to offer some diagnostic steps. My apologies if that was perceived otherwise. Regarding other JQL challenges, listing too many often leads to "spirited responses" from our vendor's team. Some I watch for are: non-deterministic behavior of null versus empty fields, sorting…

Hi Irina, Perhaps try this. I am guessing that your filter contains a bit more (e.g. your project name), so please adjust as needed. I added some line-breaks to make it easier to read; you may remove those. project = myProject AND ( labels IN (uiux-devs, fe-team) OR assignee IN ("Irina Jansone", "team member 1", "team…

I wonder if that smart value has more structure to it, or a different value than you expect. Two things to try to learn more: * Before your condition in the rule, add an audit log action to write out that smart value and see what is in it * Use the information in this article which helps to identify the names and structure…

Hi, Douglas! A few things I noted in your rule images: 1) In your condition you are testing Lookup Issues information, but you have not used the Lookup Issues action. That needs to happen first to load up the data with a JQL statement to look for any missing sub-tasks. 2) In your condition JQL, there are a few issues: *…

Hi @Kelly Arrey The "Mark as Done' sets the Epic Status, which then also allows the epics to vanish from drop-down lists...rather than cluttering them up. We use an automation rule to set it, similar to what you are doing with the workflow post-function on transition. Kind regards, Bill

Hi @Ben Weisman Yes, and...to what Esther suggestions: Just in case the field was empty (or gets cleared), you could add some default handling. For example, add the pipe symbol followed by a default value of the word EMPTY for the original value: {{fieldChange.fromString|EMPTY}} Kind regards, Bill

Hi Evert, Nope, you definitely can have a scheduled trigger rule without JQL. And, are you using the Cloud or Server/Data Center version, as each has different batch processing options? For example for Cloud: * trigger: scheduled on the cycle you select * action: Lookup Issues with JQL replacing your project name and any…

I haven't been able to learn that info after a few searches. If you are on a paid license of Jira, please consider working with your site admin to submit this as a support ticket: https://support.atlassian.com/contact/#/ And once you hear from them, please consider posting what you learn to benefit the community. Thanks!

Hi @louise.simmonds I do not believe that view is possible with Jira Cloud at this time, and I found several suggestions to add it, such as this one: https://jira.atlassian.com/browse/JSWCLOUD-14771 As a work-around you could try the pie-chart gadget for a dashboard by assignee. Kind regards, Bill

Douglas, regarding your last sentence: But the difficulty now is create a automation that When i change the type of project, create a subtask if it doesn't exist I believe the only way to do that is to perform a JQL check for the sub-task with that summary and parent, check for its presence, and add it when missing. The…

Hi @Laura Ramirez It isn't tracking by status, but when issues change the category of the status, that value is set as the statusCategoryChangedDate and this would include changes from/to the status categories: * To Do * In Progress * Done For example if you checked that date/time field for done issues it would provide…

Thanks for clarifying, @Nynke Polet You are describing a throughput chart for a Kanban team, counting based upon sum of the estimate/week (e.g. story points/week) and displayed over time. Unfortunately that is not available with out-of-the-box Jira Cloud. You can see the count of issues done per week with Atlassian's…

Yes, that is correct; when using a backlog only status values mapped to the leftmost column of the board are shown in the backlog view.

I'm glad to learn it is resolved. How did you fix it? Thanks!

Hi @Nynke Polet To help the community offer you suggestions, would you please clarify your use case: * How does training session work flow? You note an example of 1 to >100 training sessions for a Jira issue, so do you incrementally complete those sessions or are they all done at one time? * If the sessions complete…

Hi @Chris Green If you stored the email addresses of the interested parties (who are not Jira users) in a custom field, you could use the automation for Jira features to send them emails with updates. Please look here for information and examples of automation if you want to consider that: *…

Hi @Brock Jolet No way to return TOP 1 as JQL isn't a SQL. Please try: {{lookupIssues.first.key}} or {{lookupIssues.get(0).key}} (Lists use 0-based arrays, I think.) Kind regards, Bill

Hi @Shoji Thomas -- Welcome to the Atlassian Community! Adding an issue to a sprint does not change the status. Thus you may want use a trigger to check for a change to the Sprint field, and add some conditions to confirm the sprint is in openSprints() for when this occurs during sprint planning. And also, you may want to…

Hi @Jofre Bosch Would you please explain how your team is using Scrum? Teams use Sprint Planning to confirm the goal they plan to achieve, the work items to meet that goal, and a plan to implement those work items. This automation idea seems like it could create a sprint backlog the team has not seen or planned, leading to…

Hi @Pascal Ambros -- Welcome to the Atlassian Community! You have identified the smart value you need. Now use an advanced compare condition to test it for the values you want. If that does not help. please post images of your complete rule and the audit log showing the details of trying to run the rule. That will provide…

Hi @Doug Levitt Your conditional expression to find the linked issues with a "Done" status is returning a list of comma-separated values. If you stick that into a created variable, e.g. varDoneList, you could then count them: {{varDoneList.split(",").size}} To get the non-done count, just subtract that from your total…

Hi @Yap Seng Choon -- Welcome to the Atlassian Community! That option is for the Server/Data Center version of automation rule's scheduled trigger. For Cloud, the batch processing option is with the Lookup Issues action. Please note: unlike the batch processing for Server/Data Center, lookup issues does not support all…