Bill Sheboy Expert

Are you using Jira Cloud, Server, or Data Center version? Would you please post an image of your complete rule, and audit log details, for some context? The example I provided definitely works in a rule with any trigger for Jira Cloud, as it uses the result of a lookup issues action, not for a sprint from a sprint-related…

Hi @Michael Shaffer Sr You appear to be using Jira Data Center version. Is that correct? If so, the lookup issue action does not yet support all fields in the issue. Here is the suggestion to add those: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877 When the lookup issues action was first added for Jira Cloud, it…

Hi @Luther -- Welcome to the Atlassian Community! The built-in burn charts cannot be added to a Jira dashboard. There are marketplace addons (free and paid) which may be used as substitutes. Some are aware of sprint measures, and so appear similar / better than the built-in report (in my opinion). Other can use any filter…

Hi @Pieter Helsen How are your teams using the resulting "Impact Score" values? What process steps does it drive? Isn't the result of quick win items scoring to the top (and then quickly completing to leave the list) an indication the inputs to the scoring are accurate? Or perhaps instead that there is something missing,…

Hi @Mattia Battan Yes, and...to Trudy's answer: Smart values are name, spacing, and case-sensitive, and sometimes they do not match the displayed name of the field on the issue views. To confirm you identify the correct smart value for your field, Final Solution Date, please try the steps in this how-to…

Thanks for that information. I suspect the labels field is sent as an array of values in the JSON as described here: https://support.atlassian.com/cloud-automation/docs/advanced-field-editing-using-json/#Labels As a suggestion, labels are used for many things by teams, and so your ServiceNow ticket number could be tampered…

Thanks for that information, David. Rather than moving the data to another custom field, have you tried using one of the encoding functions on the original multi-line field and then sending that in the message? That should preserve the characters using the relevant protocol.…

Hi @james_vanderhaeghe Yes, and...to Rebekka's answer: There is a suggestion to add the ability to import values to populate a rule's lookup table from an external source. Please watch / vote for it to see progress: https://jira.atlassian.com/browse/AUTO-472 Kind regards, Bill

Hi @Tomislav Tobijas You are quite close to the answer...It helps to post the entire response to the audit log and confirm the response structure as that will show using both the body and fields to get at the data. {{webResponse.body.issues.fields.customfield_12345.sum}} That works for me for Jira Cloud, so please confirm…

Hi @Maximiliano Crosa -- Welcome to the Atlassian Community! First thing, what problem are you trying to solve by doing this? What will you do with the min and max once you have them? Knowing that may help the community to offer better suggestions. Thanks! Until we know that... Out-of-the-box JQL cannot find things like…

Hi @Mark Van Loock -- Welcome to the Atlassian Community! How are you getting the issue information to send to ServiceNow: outgoing webhook configured from Jira admin functions, automation rule, app calling the REST API functions, etc.? Knowing that may help the community to offer better suggestions. Thanks! Kind regards,…

Hi @Hamd Khan -- Welcome to the Atlassian Community! What problem are you trying to solve? That is, what is the purpose of your question? Knowing that may help the community to provide better suggestions. Kind regards, Bill

Hi @彥宏(Luke) 劉 Please post an image of the audit log details showing your rule execution. That will provide context for which steps in the rule processed. What is the scope of your rule: project, multiple-project, or global? To access / update issues on other projects, the rule cannot have project-scope. To confirm the…

Hi @Benjamin Brostian Yes, that would be possible. The rule could be triggered on work logged, and then compare the total time spent to the original estimate. You may want to include an indictor in the issue to note the message has been sent; with that, a condition may be used to prevent re-sending the message. To get you…

Hi @Pieter Helsen Have you considered triggering your rule on changes to the inputs of the Impact Score instead? That may work for some fields, such as Goal Impact, but it does not appear to work for Insights. Kind regards, Bill

Hi @Fatima Alghannam -- Welcome to the Atlassian Community! I do not believe there are smart values or JQL to do that for a project. However, if your rule is triggered on Project Created, it could call the REST API function to find the workflow schemes associated with the project, using the Send Web Request action, and…

Hi @Javanshir Mustafayev As others have described, the advanced branch on smart values will help in this situation. Specifically, you could use the additional smart values around field changes: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/#--fieldChange-- These would allow both adding the…

That will be more difficult once the time is logged versus just changing remaining or original estimates. Disclaimer: I have never tried this with an automation rule. As you can see from these manual update instructions, worklog changes require an edit (or delete) of the specific work…

Hi @david_levy When you note: ...it always retrieves my variable as a single line without the new line char How do you know that? For example, if you are writing that field to the audit log, the newline and carriage return characters will not display. The log view appears to display them as a single space. Perhaps if you…

Hi @Eduardo Lima I suspect this behavior happens because the smart value aggregatetimespent is dynamically calculated or its typing is integer-only. A work-around is to use a math expression, as shown below: {{#=}}ROUND({{aggregatetimespent}} / 3600, 2){{/}} I added the ROUND() function to limit the number of digits after…

Hi @julvon -- Welcome to the Atlassian Community! For your scenario of updating the Description field, that is possible using an automation rule. The rule could be triggered on changes to the four custom fields and then update the Description. The key to this scenario is the layout of your Description field. For example,…

Thank for that information as it confirms my earlier hypothesis: the fields are not yet supported by the lookup issues action for Jira Data Center. Please see the work-arounds I suggested earlier for alternatives.

Hi @Zak Jacobson -- Welcome to the Atlassian Community! Does your response already have line breaks? If so, you could try using the code snippet / markup for text fields: {code:json} your JSON expression here {code} https://jira.atlassian.com/secure/WikiRendererHelpAction.jspa?section=advanced Kind regards, Bill

Hi @Aaron D -- Welcome to the Atlassian Community! In my opinion, this is a bit challenging in rules: the sprint field can behave like a single value, a list, or an array...apparently based on context. Here is an approach I believe works:…

Hi @Nathan Phillip Brink -- Welcome to the Atlassian Community! Short answer: For me it was experimentation and repeatedly reading the docs. That toDate function can be found here: https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/#Converting-text-to-dates Longer answer: The…

Hi @Laurence Fortin -- Welcome to the Atlassian Community! A possible smart value to use for this scenario is: {{issue.timetracking.originalEstimateSeconds}} And so adding to {{now}} would be this, with a default value of 0 just in case: {{now.plusSeconds(issue.timetracking.originalEstimateSeconds|0)}} That would be in…

Hmmm... Calling that one stand-alone (without the branch), I would only expect that to fail due to an actual collision or a problem on the Atlassian side (e.g., error in the function). With a branch which could be on more than one thing, those are executed in parallel and asynchronously, with no guarantee of when the…

Hi @Rebekka Heilmann _viadee_ and @Gary Spross I wonder if the documentation has not caught up with the possible return error codes: I found this old change notice to include 409 errors for update collision cases for issue transition. Perhaps that error is returned for other endpoints with collisions as well.…

Hi @Joseph Based on your additional scenario information, I believe you can compress some of that logic down a bit... This approach would use conditional logic to update (or not) a field using advanced edit with JSON syntax. Similarly the text for the comment could be dynamic. I would expect this to reduce from 5 rule…

Let's back up a bit... What problem are you trying to solve? That is, why do this? Knowing that will help the community to offer better suggestions. I was suggesting how to create a Jira issue, one for each month. Perhaps you instead mean something different, and not creating issues. If you did need to create the issues,…