Dick Community Champion

Hi Florian, Swimlane filters are defined in the board configuration window, tab swimlanes. Base swimlanes on: allows selection (it's a pulldown menu). You can choose Queries, then you get the interface where you can make swimlanes with issues you gather using JQL. Kind regards, Dick

Hi @Florian Foohs , Welcome to the Atlassian Community You filter in all Jira issues that go on your board using the board filter. From this bunch of Jira Issues, you filter a subset for each swimlane using jql Any issues that are left, end up in the "Other issues" lane. So once you filter in the test executions in their…

Hi @Natalie Keane Please check the JQL in the top position of the sheet. This JQL is responsible for finding the issues that are displayed. If your query is not "finding" tickets with status 'Done', the status column in your sheet will not have any 'Done' issues. Kind regards, Dick

Hi @Andy Kettle , Nothing wrong with a good pinch. ;) You're welcome, Dick

Hi @Наталья Медисова , Welcome to the Atlassian Community. What type of board are you using, Scrum or Kanban? Can you provide some background as to which statuses you've used for each board column? A picture of the Board configuration - Columns would clarify a lot. (Your use of Status New for column Backlog and having a…

Hi @Andy Kettle Well done to you! Know that you still can have the "there are no bugs" feedback to the user by adding the original if statement: {{#if(equals(varRenewalsCount, "0"))}}There are no bugs{{/}} Kind regards, Dick

Hi @Andy Kettle I think your closing {{/}} just above </table> should move up all the way to the first line (as that's closing the fist if statement. then you need the opposite if statement to handle your table (in its totality, so you'll end up with an {{/}} under the </table> tag. Kind regards, Dick

That's awsome! I'm glad you got this into a rough diamond. Just curious: how did you find out that there were still automations running on archived projects in the first place? Thanks for accepting the answer. Dick

Hi @Lindsey Dobson , Welcome to the Atlassian Community It seems you're using expressions that do not exist in the Atlassian documentation on smart values: smart-values-text-fields and smart-values-math-expressions/ * Text comparisons are made using match instead of contains {{issue.summary.match(".*(lo).*")}} -> lo…

Hi @vince margaria As your automation is only capable of processing changes in subtasks being modified, you really should put a condition between trigger (green circle) and first action (blue circle): if issuetype = subtask Happy automating, Dick

Hi @vince margaria No worries, I'm non-native as well (vous-êtes Francophone?) :) Your automation takes care of occurrence number 1: A sub-task is edited. I think it is also necessary to do the calculation if the parent (story) is changed. It could very well be the case that the due date of the story is set to a different…

Picking the Database of our own datacenter Jira clean, I noticed that the context (or at least the project id's that an automation is working for) is found in the table called: [dbo].[AO_589059_RULE_CONFIG] This table even holds the State field with values enabled/disabled. Onwards and upwards ! Dick

Hi @Zydek, Rafal , Welcome to the Atlassian Community I did a search and came to a page with a list of vendors and their respective database table names they use: Atlassian list-of-jira-server-ao-table-names-and-vendors-973498988.html The Automation tables start off with AO_589059_ Hope this will fix your blocker Dick

Action: Lookup issues should be: "Epic Link" = {{issue.key}} as the trigger issue would be the story, not the epic. The branch puts focus on the parent issue, which is then referred to as issue object. As @Bill Sheboy pointed to me below, the sum part is a List expression, which is indeed perfectly fine without preceeding…

Meanwhile, I did a search and found a very nice way to get the maximum due date of a list of due dates. @Trudy P Claspill was so kind to provide an answer that used this here; Parent-issues-have-to-inherit-the-latest-due-date-of-child It is not a complete answer to your question, but its potential to help find the value…

Hi @vince margaria , Welcome to the Atlassian Community. First step: Your trigger is quite wide, it allows the automation to run on epics, stories and sub-tasks. Each of these issuetypes would require a different approach, if I read your problem correctly: * if the due date of a story is updated, you want to evaluate the…

Hi @Marc -Devoteam-, It's the line of thought in the article and the use of smart values (kindly mentioned by @Kai Becker as well) that are very similar to the problem described here. There's more than one road leading to Rome :) Dick

Hi all, A very similar question has been asked previously in this community: How can I set a custom field date one week *before... I'm hesitant to say that Google is my friend, but here it helped... Dick

Hi @Rita Arellano , You can make a manually triggered automation that you invoke using the "More" menu when you have the epic selected that you want to recalculate. The automation would have the same calculations as the automation you already have (for each story point range), though you wouldn't have to branch for the…

Hi @Ragini Sharma , Welcome to the Atlassian Community. I take it you've studied Atlassian explanation on how auto scheduling works in Plans (Roadmaps). This page and its subs refer to a number of assumptions/actions/interpretations that step-in if there are shortcomings in the data necessary for a straightforward…

Hi @Gal Fatal , You can setup an Automation that is triggered by a change in the assignee field. You can check the previous and new value for this field with their respective smart values: {{issue.assignee.displayName.fromString}} and {{issue.assignee.displayName.toString}} If the latter is empty and the former isn't you…

@Alex Koxaras -Relational- I'm sure @Eitzaz Haider has the best interest of the customers in mind. Perhaps this question was an investigation on his behalf on how the standard notifications could be replaced by a more concise notification, thus catering more profoundly to his customer's wishes. All in good spirit, Dick

Hi @Eitzaz Haider , You can set up an automation that sends an email when a comment is added. Formatting the email content is described very well by Atlassian on the smart values pages: smart-values-in-jira-automation Note: the comments are an array of strings: you need to consult the automation examples given in the List…

Hi @Yves MOUAFO , I'm glad you have conquered Automation. If you mark this question "answered", other people with a similar question can navigate more easily towards the answer as well. Thanks, Dick

Hi @Kevin Doyle and @Marc -Devoteam- Why aren't you using Jira smart values for this? {{request.key}} {{request.summary}} would be my personal favorites in this. Hope this helps, Dick

Hi @Yves MOUAFO At the start of an automation, the automation needs to know the (list of) ticket (s) onto which it has to do something. In your case it cannot fathom that a sprint has a number of tickets in it, so you have to tell that to your automation by using a foreach clause. Something in the line of foreach issue in…

Confluence would be a separate purchase. It's also made by Atlassian, hence the synergy between Confluence and Jira. 

Hi @Andrea To be able to edit a board, see options in its configuration, you need to be board administrator. Best of luck, Dick

Hi @Priyanshu Welcome to the Atlassian Community. Confluence would be the perfect match for you. You can easily switch between Jira and Confluence, provide the necessary background of the project, linked Jira issues, even make use of templates for team retrospectives. Documenting is best done in a good documenting program:…

Hi @Samir Vaja Welcome to the Atlassian Community Stories and Tasks reside on the same level. Sub-tasks are the tasks that reside under Stories. So there's a level difference between task and sub-task, which you can see in the below picture The Kanban board you see here, has swim lanes for epics selected from the…