Bill Sheboy Expert

Although there are probably addons for this capability, I was noting something a bit more home-grown using: * create a variable in the rule with all of the name|key pairs (e.g. CompanyName1|CL1, CompanyName2|CL2), use smart value list filtering to extract the match, and then parse out the client id; or * entity properties…

Please try writing that smart value expression to the audit log prior to the link action. That may indicate if it contains what is expected, or if there are any stray characters. For example: START{{issue.description.split("\n").match("([A-Z]+-\d+)").distinct}}END Will show if that contains only an issue key between the…

Hi @Graunephar Thanks! I thought that the {{project}} smart value was only available with the Project Created trigger. For your question, I believe you will need to use smart value, list filtering to match on the name and then grab the id value:…

Hi @[deleted] -- Welcome to the Atlassian Community! JQL is not a SQL, and cannot perform many native functions such as nested queries, joins, etc. Some work-arounds for your need depend upon how often you need this: * Need just one time:* Manually run a query on the the child issues (with relevant criteria) to gather…

Hi @David Leal Are those company-managed or team-managed projects? If they are company-managed the projects share the definitions of the status values (by name and id), but if they are team-managed my understanding is the status id values are different and so the name-based query may be causing confusion. Next, that second…

For the missing data in the Confluence macros, I recommend working with your site admin to submit a ticket to Atlassian Support as they may not know about that symptom: https://support.atlassian.com/contact/#/

Replacing my response... I did not know there was a plusBusinessHours() feature. Well done!

Hi, Owen! There appears to be a typo in your expression: a missing parenthesis to close the match() so perhaps that is the problem causing the error: {{issue.description.match("([A-Z]+-\d+)")}} I noted earlier that I do not know if that other post's regular expression works, so I suggested the other technique with split()…

Thanks for clarifying that! With those custom fields, you could set the values using Automation for Jira rules...such as on status transitions. Please take a look at this overview and example rules, and if it looks like it might help try creating a rule to make the updates. If you get stuck, post images of your rule and I…

Correct; using an advanced issue search you could see the fields you want and the current status, but not the history of status values over time. To do that you would need to view an individual issue or use an addon tool capable of visualizing that history.

Hi @Malavika L P What have you tried thus far to solve this need? If you have a rule started and are having problems with it, please post images of your rule and the audit log details, and describe the problem to provide context for the community to offer help. If you have not started yet, please review this documentation…

Hi @Phil Bustin -- Welcome to the Atlassian Community! There is nothing built-into Jira Cloud to create a report like that. I recommend proto-typing the report you want on paper or in a document, and then investigate reporting options in the marketplace for addon tools to meet your need. Kind regards, Bill

Hi @Esteban Borja Lopez First thing, please check your site settings for your business hours to confirm the start/end of the business day. Next, you appear to be multiplying by 1440 which is the number of minutes in 24 hours, not 8 or 9 hours, or however long your work day is by the settings. Regarding the holidays, I…

Again, if you have a lot of clients I would advise against the if/else type of rule due to the maintenance challenges. That noted... How about something like this, using the Create Variable action to save the result before testing in conditions... * trigger: Issue Created * action: Re-fetch (This is important for the issue…

First...how is your rule getting triggered: when the issue is created, or when the reporter is later assigned, or something else? That will help to pick the rule trigger. Once you have the reporter set, you can use the text functions to split out the domain to then test with conditions, such as with substringBefore():…

Hi @Robert Levine -- Welcome to the Atlassian Community! I cannot discern if you are using Jira Cloud or Server/Data Center; I am going to assume Cloud... If you have just a few email address domains and clients to parse, you could extract the domain and use if/else conditions to set the client. If you have a lot of…

Hi, Fred. I have not tried the rule in that post so I cannot confirm any changes. Perhaps that regular expression is sometimes not matching for other reasons, such as... In answering another question about extracting links from the description, I found they are stored as "smart links" in the markup. Perhaps the same is…

Thanks for clarifying, Aaron: you were noting the problem of searching for JQL reserved words, such as with this syntax: summary ~ "\"IN\"" OR summary ~ "\"OR\"" I do not think searching for items in the reserved words list is possible unless the system settings are changed to do so...And per the documentation that can…

That's interesting...I recommend waiting to hear back from support as the behavior seems different for the different fields with multiple possible values.

Hi @Curie Fry House -- Welcome to the Atlassian Community! That is not possible yet with the built-in features to access that information; only the manual move is with the UX. Please see this suggestion to add the feature for automation and this related community post: * https://jira.atlassian.com/browse/JSWCLOUD-21481 *…

Hi @Jimmy Petersson First thing, I am using Jira Cloud so I cannot confirm the following for Server/Data Center version... There is an defect that when the incoming webhook trigger fires, JQL in the rule is executed as an anonymous user: https://codebarrel.atlassian.net/browse/AUT-547 That one looks like it was fixed,…

Hi @Aaron Minoo Are you asking about searching for a string which contains parentheses? If so, there is a known issue where escaping such special characters does not work for built-in JQL features: https://jira.atlassian.com/browse/JRACLOUD-62859 It appears that using the following syntax will return issues with…

Hi @Krzysztof Kołodziej You seem to be asking: how do we manage, build, deliver, and support value for our product? Essentially, how do we do the entire value stream? One starting point would be to recruit and hire knowledgeable and experienced product managers, project managers, software engineering leads, and people…

How is your Labels field getting populated into one column in that spreadsheet? I ask because when data export happens, any of the list fields produce multiple columns in the export result. For example from your image, at least one of the issues' Labels fields has 3 values, which in an export leads to 3 columns. This…

Thanks, Fred. That seems a bit different from what you described...perhaps that rule is assuming part of the problem has already been solved? You noted two steps: * for an Epic with child issues, gather the child issues' keys into a comment. (I suspect you could also skip rule #2 and just add the links immediately.) *…

Hi @Irina_Bel_Stiltsoft_ Have you tried to use replace() to substitute a space or empty string for the newline character before the test? For example: {{issue.comments.last.body.replace("\n","")}} Kind regards, Bill

Hi @Fred You note that you have an automation rule and that it failed to do what you wanted. Would you please post images of the rule and the audit log details, showing where it did not work as expected? That may help the community to offer suggestions. Thanks! Kind regards, Bill

Hi @seelye.naomi -- Welcome to the Atlassian Community! No, that is not possible. Here is the suggestion from 2014 to add that feature, which you may watch/vote for to see progress. The built-in gadgets apparently haven't been updated in many years so that improvement is unlikely to change.…

Hi @George Lee -- Welcome to the Atlassian Community! As you describe the team is apparently using scrum (and sprints) I am unclear how that report would help the team work together on delivery. Instead it might have the unintended consequence of optimizing one type of work. If instead you are looking for areas to improve…

Hi @Bhalchandra Wagle {{fieldChange}} is relative to whatever field(s) changed and caused the trigger to fire, and so the ambiguity could be the problem. Perhaps try using {{changelog.summary}} instead. And adding to what @Fabian Lim noted, tweaking the summary may be problematic and brittle as a solution. Instead consider…