Bill Sheboy Expert

Hi @Raju Mandapaka You may use the substringAfterLast() function to pull off the key from the text: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#substringAfterLast-String-separator- {{createdIssue.url.substringAfterLast("/")}} That will get just the key. If you want to have that as a…

Hi @bertrand.drouhard Yes, and...to what others have noted: there is an open suggestion to add an automation trigger for the update/delete of comments, which you may vote for/watch to see progress. https://jira.atlassian.com/browse/JIRAAUTOSERVER-127 Kind regards, Bill

Fascinating, and I am glad you got this to work! You only need re-fetch if you plan to compare/update the field later in the rule, so you can drop the last re-fetch if you wish. Each re-fetch call adds potentially several seconds of execution time so use them sparingly. As there appears to be some timing-dependent things…

Hi @Mark -- Welcome to the Atlassian Community! Have you tried using this syntax to get the value of the field: {{issue.customfield_10413.value}} Kind regards, Bill

Hi @Arto Saari -- Welcome to the Atlassian Community! Yes, that field is accessible for issues or for sprints (as Hana notes for sprint-related triggers). The issue's sprint field is a list type, and so you need to select a specific sprint to get at the End Date...or you could just find the maximum one…

Thanks for the image! In the image, you have hidden the board names. Are those duplicates for the same or different boards (in different projects)? If for different projects, there is a known issue where the dropdown does not filter for a specific project. The suggestion to fix that is…

Well, that seems incorrect as branches which evaluate to one-and-only-one issue should run in-line, and not asynchronously. Would you please post an image of the audit log details as that may show something to explain this behavior? Thanks! And if that shows nothing useful, let's try eliminating the branches and…

Hi, Ryan. There is a Re-fetch action to do that. And yes, you would need to re-fetch after each edit.

Hi @Ryan Wolfe For a question like this, please consider posting images of your rule and audit log, showing the details of the execution that does not work as you expect. That context may help the community to offer suggestions. Thanks! Based on what you describe, I hypothesize a few things are happening: * When you edit a…

I am glad to learn that helped you. Please consider marking this question as answered; that will help others in the community find solutions faster when they have similar questions. Thanks!

Hi @Dimas Oliveira Would you please post an image of what you are seeing for the list of sprints on the issue create view? That may provide context for the community to answer. For the orphaned sprint, that can happen when a sprint was created for a board/project and the board/project have since been deleted, as described…

Yup, JQL is no ISO-flavor of SQL :^)

Hi @Andreia Lopes -- Welcome to the Atlassian Community! What you are describing would no longer be lead time. Lead time is the duration from when a request is created until it is completed/delivered. You seem instead to want some form of cycle time, measuring from one particular point (e.g. status for start of work) to…

Hi @Laxminarayan Pimpdae -- Welcome to the Atlassian Community! I respectfully suggest having a conversation with your team's scrum master or agile coach about how you are managing work, what reporting you need, and what problems you are trying to solve by organizing as you describe. They may give you ideas for…

Hi @dennis.werner That is not possible with out-of-the-box JQL. The Epic Link is currently a field for company-managed project stories/bugs/tasks, and the field you are trying to query is Epic Name...which is part of the epic. As soon as you filtered down to Story or Bug the epic name couldn't be checked. How often do you…

Hi @B -- Welcome to the Atlassian Community! At this time, I believe the Pull Request URL smart value is only available when the rule trigger is one of the development ones, such as PR created. Kind regards, Bill

Hi @zakaria abbar As you have ruled out an invalid email address, consumed as spam, automation rule error, and license limits, you may need to contact the support team for help. Please work with your site admin to submit a ticket to them here: https://support.atlassian.com/contact/#/ Once you hear back from them and learn…

Hello! I wonder if Jira is incapable of handling a value which does not lead to an exact number of hours, minutes, seconds; this may be a binary/decimal/time representation and conversion issue. That is, when you divide by 60 it is no longer possible to represent the value as a time, and so it cannot be stored in that…

Hi @Carlye Petoff I do not believe it is possible with out-of-the-box JQL to get the last assignment date. There may be something in the marketplace to do this, or you could pull it from the change history with the REST API (one issue at a time). A work-around going forward would be to add a custom field to store when the…

Hi @Janakiraman S First thing, I am using Jira Cloud and not Server so my observations may be wrong. I have noted that with JQL and other things in Jira, the time fields have discrete units of measure limits, probably related to the numeric conversion of values to whole minutes. For example: * This works as a…

Hi @Manon Bourgeois You may watch this page to get a weekly email of the changes being rolled out: https://confluence.atlassian.com/cloud/blog/2022/01 Kind regards, Bill

Hi @Kelly Brewer Yes, and...to what @John Funk and @RISHAV KUMAR GUPTA noted: Here is the suggestion to add configurable swimlanes for team-managed projects. You may vote for/watch it to see progress on it: https://jira.atlassian.com/browse/JSWCLOUD-17580 Kind regards, Bill

Hi @Micah Barnott -- Welcome to the Atlassian Community! Are you using automation for Jira to do this messaging to Slack, or something else? If you using automation for Jira, would you please post an image of your rule for context? That may help the community to offer suggestions. Thanks! Until then...When you note the…

Hi @Andrea Robbins For JQL the summary field does not support the IN operator. Instead you could try the contains operator: ~ Kind regards, Bill

Hi @Tim Savage Yes, and...to what Chris notes: What do you mean by "keep track of how our sprints are going"? For example, if you want to assess progress based on what the teams have planned for their sprints, please consider using a dashboard with the sprint health gadget, with one gadget for each team:…

Ho @Peter Wind That is not possible yet; you may only read the existing column configuration. Here is the suggestion to add/change columns to a board configuration: https://jira.atlassian.com/browse/JSWCLOUD-20535 Kind regards, Bill

Thanks for that information @zakaria abbar What does it show in your rule's audit log details when the email does not send? And, have you checked if the emails are being marked as spam for the receiver, as @Charlie Gavey suggested?

Looking at your image, you are using the Jira Workflow Toolbox's version of automation, and not the Automation for Jira app. I have no experience with that tool, and I recommend taking a look at this documentation for the tool to see what you can…

Hi @Brock Jolet I recall reading another post about the Atlassian team working on preserving typing in created variables, rather than cast to string. Until then, you probably need to either: * save the Lookup Issues information in a created variable, and then use split() to pull back into a list before using size()...or *…

That matches my experience; there are still some issues with automation and which markup can/cannot be used for text fields.