Darryl Lee Community Champion

Hi @Nancy Wilson - so I'm assuming your customer-facing documentation is in Confluence. Would that be correct? What you included looks like it's from Jira audit logs, not Confluence. Here's what a link to the logs in Confluence looks like: https://YOURSITE.atlassian.net/wiki/admin/auditlogging.action And here's what it…

Glad this worked for you Aaron - do you think you could click on the "Accept Answer" button? Thank you!

Glad it worked. Yeah, it's a bummers variables don't work more reliably. Note there's a minor typo in your headers. Should be Content-Type, I think.

And you also tried *without* using an intermediary variable?

AHHH, ok, you just want THE SAME URL on every Start Work screen, and maybe some text telling people what to do with that URL? You should use a Message Custom Field, which can include HTML, like your URL. (so you will need include the <a href...</a> tags.) There is a little documentation on this field here:…

Oh, I did have one thought - can you post a screenshot of what was actually in {{githubBody}}? Did you include the braces and everything so that it generated something like: {"tag_name":"v1.0.0", "target_commitish":"master", "name":"v1.0.0", "body":"Description of the release", "draft":false, "prerelease":false,…

Again, I would advise against using "Create variable" to create your {{githubBody}} an {{githubUrl}} because as mentioned before, variables are a little... unreliable, having to do with what order Automation runs stuff in, etc etc. Instead, I would do what you did before, putting the URL directly into the Web Request to…

THIS is a much better answer!

LOL. Yeah, sometimes the less elegant way is probably simpler. :-}

Hey @Jeffrey Lyons and @Mark Segall .... Well, you could use the Web Request action to make a POST to somewhere on the Internets, and you could schedule that to run against a JQL query against your FEATURE project every day. The problem would be that I'm pretty sure Google GSheets and Drive's APIs require more complicated…

Oops, and because I wasn't careful in my typing, I forgot the ": " after "Services", which is what resulted in that extra one before the first repository.

Hi @Felipe Bonezi -- So the trick is that Variables outside of Branches don't always work so well. I got your regexes to work by making one small change. I put the first one directly into the Advanced Branching block: Once I made that change I was able to create variables inside the branch just fine and echo them out to…

Hi @Jonathan Nuñez -- If you want automatic assignment based on a custom field like Country, then you could use Jira Automation to create a rule that does this, although if you have a lot of Countries, this can be cumbersome. Oh look! This exact rule is part of Atlassian's Automation Template Library: * When an issue is…

Hi @jira_admin_cu - I think the problem is the way that you're specifying the username/password in the URL is not valid: https://username:password@https://dev.atlassian.xxx.com/secure/attachment/SCDOPS/10000/SCDOPS-1655/image-2022-11-28-11-04-44-590.png In fact, I don't think there's a way to link to a password-protected…

Ohey @Jamshaid so URL fields are only *clickable* when you are VIEWING a ticket, not in the Transition like your screenshot. (That screenshot is from Cloud, but Server/DC presents similarly.) If you are wanting a clickable URL in a transition screen... I think you can do that in a Field Description, so you wouldn't be able…

Hi @Jamshaid - I see in your other question that when you set the value you include HTML with the <a href> anchor tags. I'm pretty sure you should only be setting the URL as the value.

Hi @Jamshaid - I believe the value for the URL should JUST be the URL: https://uat.cybersage.us/#/analysis You should not need to include the HTML with the <a href...></a>.

Hi @Dennis_H - a previous client used Table Grid which does include the ability to aggregate data from a column (eg as count, average, or sum.) I would be concerned about data migration. Table Grid does have a REST API, so if you can extract data from Elements Checklist, it should be able to somehow import it into Table…

Hi @Ste404 - I think you'll actually need to convert it into Confluence Wiki Markup format which looks like this: ||heading 1||heading 2||heading 3||<br>|cell A1|cell A2|cell A3|<br>|cell B1|cell B2|cell B3| So in your case, something like this might do the trick: "||Key||Name||Created||Updated|| {{#lookupObjects}}…

Hi @Tommy -- Ooooh, yeah, that's tricky and cool, and I love/hate it! At first I thought you might be able to do a "pull" from Jira, using Automation's Send web request action But ugh, that would require Excel being able to "publish" data as JSON, which... while you can "create" JSON (Output Excel table data as JSON), I…

Or maybe something with the toBusinessDay, toBusinessDayBackwards, or plus or diff using BusinessDays (business days are considered to be Monday to Friday, 9am to 6pm) Sorry, date calculations usually make my head hurt. But maybe you or others could figure out something clever with those?

Unfortunately, I think the situation is still as @Jack Brickey wrote in Nov 2020: Automation runs at UTC. I wish you could choose your Zone but not there today. I wonder if maybe you could use the {{now}} Smart Value and combine it with the convertToTimeZone function to write your own Advanced compare condition. I'll think…

Hi @sadams - if you simply omit the project in (ABC, XYZ) clause, it will search across all projects.

Hi @Anette Noll -- Unfortunately the only validators offered by out of the box do not let you check user roles for making a field required (or not). https://support.atlassian.com/jira-cloud-administration/docs/use-workflow-validators-for-company-managed-projects/ To validate based on user role, you'll need a third-party…

Hey @edburns and @Alex Koxaras -Relational- : Aren't story names in the Summary? When I did some testing with just "2*pictures" it matched this test issue "Need New Part - Part number 2". Hrm, weird that the * picks that up, despite the "pictures". If you can are able to constrain your search to this decade (2020-2029),…

Awesome - glad to hear it worked! Would you be so kind as to click on the [Accept answer] button up there? Thanks?

Hi @Aaron Coonce If you are using Automation for Jira (and is this on Server where you would have to pay for it or Cloud, where it is included?), can you please post a screenshot of the rule you have tried so we might be able to see where things are going wrong? Because this should be pretty straightforward. We'd want to…

Found a ScriptRunner example here: https://community.atlassian.com/t5/Jira-questions/How-do-I-make-the-second-field-of-a-cascading-select-field/qaq-p/229174 

So by default, if you make a cascading select field required, it only makes the parent required. Here's a bug that confirms that: https://jira.atlassian.com/browse/JRASERVER-21383 To make child fields mandatory, that will require an add-on that provides a custom Workflow Validator, such as one of these: * Jira Workflow…

Although you might want a full URL that's valid: { "text": "Hey! We have a new ticket on test: http://YOURSITE.atlassian.net/browse/{{issue.key}}" } (So I made the hostname similar to a real one, and with the browse/ path added.)