Bill Sheboy Expert

Hi @Petr AST With out-of-the-box JQL features, it is not possible to query the number of selections/values in a field that can be interpreted as a list. Some work-arounds are: * for a one-time/few-times approach, export the issues to another tool or spreadsheet, and perform the analysis there * using an automation rule,…

Hi @Peder Alm Have you tried using the diff() with prettyPrint and use a date/time value as an intermediary? For example, diff on now and now + your field value. Maybe something like this: {{now.diff(now.plusSeconds(issue.aggregatetimeoriginalestimate)).prettyPrint}} Kind regards, Bill

Hi @Jocelyn Aquilina -- Welcome to the Atlassian Community! I noticed a few things with your expression: it has extra spaces around the smart values, the changelog syntax is incorrect, and it is missing the math operator syntax. Please try this instead, assuming your custom field is a number type:…

Yes, and...created variables are text and not numbers. So please also add asNumber to convert them for math operations. Perhaps like this for Mark's suggested Log Action 3 Warnings + Errors: {{#=}}{{varErrors.asNumber}}+{{varWarnings.asNumber}}{{/}}

Thanks for that information. Please try changing the rule's Actor in the details. That is the person (i.e. Jira User) to whom the Log Work action will apply.

Hi @Melle van Keulen The idea would be to use functions, such as match(), to extract the text you want to search, and use the value to check in the second compare value. Another approach, suggested earlier, is to build a list of value to check in a created variable, and then iterate over them with and advanced branch to…

Thanks! That appears to be a custom field, and not the built in comment field. I just confirmed that the built-in comments field cannot be copied directly (as you have shown) with an automation rule. The only work-around I am aware of is to try to add the comments with JSON from the trigger issue, under advanced edit.…

Would you please post an image of the audit log details, showing an example where the rule triggered and the comments did not copy from the trigger issue? Thanks!

Hi @Jennifer Baum I suggested some things to try in your other post for this same question here: https://community.atlassian.com/t5/Jira-Software-questions/Automation-to-update-Due-Date-based-on-Start-Date-Original/qaq-p/2179070 Kind regards, Bill

That error indicates an issue type mismatch: between the source/trigger issue's project and the target project, Gaming Operations Board Three of the possible causes of that are... * if both source and target project are company-managed projects (CMP), the issue type of the trigger issue does not exist in the target…

Thanks for that information. Perhaps try this in your advanced compare condition: * first value: {{issue.comments.last.body.toLowerCase().match(".*(move to go board).*")}} * condition: does not equal * second value: leave this value empty How this works: * get the last comment's body * convert it to lower case * use the…

Hi @Chris Carpenter For automation rules, there is a business days, unit of measure option for diff(). That one is based on weekdays and not any site or project-defined values for working days. There is no option for "working hours". I have seen community posts where people added math operations to adjust for "working"…

Alexis, would you please post images of your rule and the audit log details? Those may provide some context for suggestions. Thanks!

The match() can return multiple values, and so if you try that as the source for an advanced branch, you can loop over the values to add each one as the Issue Edit action would be inside of the loop: * advanced branch: on the match() results* action: edit issue to add each collaborator, one by one

Thanks @yaron I recall this did work in the past as I have an example rule that previously worked for this (early last year, I believe). Further testing shows this to be quite "wonky", as the {{toString}} does work only when you add a new version as part of the issue's field edit! I noted that in the defect to give the…

Hi @yaron Please take a look at the {{fieldChange}} and {{changelog}} smart values to do that: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/ Kind regards, Bill

Hi markus.neuwald@canon.at For a question like this, please post images of your complete automation rule and the audit log showing the details of the rule execution. That will provide more context for the community to help. Thanks! Until that is shown... For use cases like this, consider how to get a distinct list of the…

Hi @Keary Norcio If I understand your use case correctly, there is nothing built-in to easily do this selection of an arbitrary unreleased version unless you explicitly select the name. A couple of work-around approaches with automation rules are: * If your version names have a standard naming convention, and you can build…

Hi @Cheryn Ng -- welcome to the Atlassian Community! Just an FYI there is a specific group for Jira Product Discovery, so you may want to look there for answers also: https://community.atlassian.com/t5/Jira-Product-Discovery/gh-p/jira-product-discovery Next, Jira Product Discovery is in beta, and appears to be based upon…

Interesting...I wonder if it is because sub-tasks are part of an issue, and not standalone issues. Have you confirmed if that custom field for the checklist is available for your sub-task type? If so, I recommend emailing the vendor on their support page (from the marketplace site) and see what they suggest.

Hi @Damian de Vries You note having tried a few things, so perhaps it would help to post an image of your rule and the audit log details. That will provide context for the community to offer ideas. Thanks! Writing automation rules often require experimentation to learn how things like mentions work in Jira. For example,…

Hi @Breen Rourke -- Welcome to the Atlassian Community! Do you mean the Smart Checklists app from Railsware? If so, their documentation describes how to do this: https://railsware.atlassian.net/wiki/spaces/CHK/pages/660766732/Import+checklists+from+Trello+to+Jira#Some-tips-on-importing-checklists-from-a-CSV-file-to-Jira…

Hi @Trudy P Claspill I believe this is the Q&A article to which @Alexis Gutierrez is referring: https://community.atlassian.com/t5/Automation-articles/79-Questions-and-Answers-about-Jira-Automation/ba-p/1363930 Kind regards, Bill

I am glad you got it to work, even if the get() after the split did not work. I had an error in my post, as after split() the list is 0-based, not 1-based, so I will update that for anyone else who reads this.

Well done! One of the tricky parts about automation rules is figuring out the smart values for our custom fields. Smart values are name, spacing, and case-sensitive...and custom fields with non-alphanumeric characters in their Field Name seem to lead inconsistent smart values. You can always use the custom field ID, but…

Hi, @Ivan Andrieiev Perhaps if you give a specific example of your exact JQL, and what you believe is not working as expected, the community can help. Asking about JQL in the abstract will not help the community understand what you are asking or lead to clarifying answers. Thanks, and kind regards, Bill

Would you please post an image of the rule Details section?

Thanks for that information, and this does sound like something solvable by reporting. I recommend creating a draft of what you would want to see, and then check if that is possible with the built-in dashboard gadgets and saved filters, or the standard roadmaps. If not, investigate the Atlassian Marketplace for reporting…

Hi @Genevieve_Green If you know how many values are possible in the checkbox, I believe you can count them as the field should be a list of checked-values. For example: {{issue.myCheckboxField.size|0}} would be the count of the number of items checked, which you could then divide by the maximum possible count to create a…

Hi @Ivan Andrieiev Adding to Mohamed's answer... Here is some good, free training from Atlassian to help when you are just learning about JQL. These are self-paced so learn the areas as you need them. https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql Kind regards, Bill