Darryl Lee Community Champion

Hi @Bryan Trummer - ReleaseTEAM - glad that worked. But about your change. If you were trying to account for my edge cases, it won't work for cases like "Jr." or "Esq." because we are still trying to match on that final " :" But also, according to the regex tester, the section '-_ is getting interpreted as a "range of…

Ooof, now that I look at that website it seems like it's only available for Cloud?I have a vague recollection of somebody at the booth saying it worked for on-prem as well, but unfortunately I came down with COVID halfway through the conference, so I very well may be misremembering.(All recovered now - doesn't look like I…

Hi @James McCusker - Unfortunately doing the kind of selective restoration of data from Confluence is not really compatible with a kind of backup scheme that you're describing. (Or honestly any kind of traditional backup system.) The structure and content of a Confluence space, including all of its pages, is stored in…

OH MAN. I realize this is a #latepost, but in my defense I was getting ready to go to Team '23 when this was first posted. THIS IS HUGE, and I am super-excited about the possibilities this opens up.

Ah Regex. Do you have a license? I'm kidding of course, but RegExes are notoriously brittle. I went over to a handy Regular Expressions Tester and came up with this {{issue.description.match("submitted by .+ (.+) :")}} And that seemed to work fine. HOWEVER. It won't work for names like: * Ray Parker Jr. * Marshall Bruce…

Hi @Andrei Margarint - just wanted to clarify, the options for customfield_11312 are things like: * google-112233 * yahoo-223344 * apple-334455 * roku-445566 And your Description field includes something like: Id: 223344 And you want to match that against: * yahoo-223344 If you happen to be on Jira Cloud, well are a few…

Hi, somebody at my work needed to limit how many issues he ran his automation on, and ended up using the limitedResults() function from GO! JQL: Essential JQL Functions. I think the problem though is that in your case, you need to do the first 100, and then the next 100, and then the next. (In his case, the automation was…

Sadly @Jonathan Smith it's still the only available option.

Elsewhere @Russell Stadler asked: For the web requests, whose token ends up saved in there? I have always felt nervous about putting a personal token into one of these rules but maybe that's misplaced. Oooh, that's a great point.Best practice would probably be to create a service account and use that, although you end up…

Welp, as often happens, I ended up going down a rabbit hole and decided I might as well write another article nobody asked for: * CMS with Confluence Automation?! Sure why not? 

Ugh, bummer that the hidden smart values I found are going to be going away. They are totally useful, so I appreciate you letting the team know. And thanks for the education about statuses. They're new to me, so now I understand Custom (personal) Statuses vs Suggested Statuses. However, the trigger documentation states:…

OK, fun experiments! When the trigger is Page status changed it looks that {{content}} contains some very useful values: previousContentState={contentStateType=custom, id=833650689, color=#8777d9, name=Ready to publish}, currentContentState={contentStateType=space, id=833617923, color=#57d9a3, name=Ready for review}} But…

Yeah, the main issue here is that Jira Automation cannot display error messages or prevent actions from happening. The "standard" way to do this is with a validator, and but in your case, you will need a Custom Validator. You've mention two different scenarios: * Can an automation that currently creates a sub-task if a…

Thanks @Trevor Angle. I guess what I really need is to see if Status was already "Ready for Publication" prior to the edit that triggers a rule. Is there CQL for that? Actually I'm not even sure how CQL would let you check "when the page was last edited". Doesn't CQL only let you do something like: lastmodified >…

@Kian Stack Mumo Systems is correct - there is a Suggestion you could vote for, but since it's remained open for almost 9 years, I'm not optimistic a vote would make a difference: * CONFCLOUD-34041 - Disabling the ability to view the "Page History" on a space HUH. I just thought of an actual use case for Confluence…

Regarding those question marks... (Thank goodness for documentation): In expressions where such strict rules are not desired, use the optional chaining operator ?.. This operator behaves in the same way as regular member access, but with one crucial difference: when accessing the property fails, null is returned. So I…

Hi @Ritika Kapoor - unfortunately Automation does not offer any interactive elements like an alert or error message, or to force a field to be populated like a validator can. You will need to create a custom validator from a paid third-party add-on like in these examples: * Cloud Workflows - Using Jira Expressions * Cloud…

Yes, if you're not interested in getting into programming or writing code, I think Power Apps and Zapier can be very valuable, and I think there is a lot of demand for skills like this. Another similar tool that is free and fun to play with to learn more about low-code environments is IFTTT.

Thanks for a great post, @Robert Wen_Cprime_ This past Saturday my son's BSA troop placed flags at our local cemetery which has several areas designated for veterans, and then they fanned out trying to find individual gravesites (via a map). Lots of cub scouts from our partner pack too.

Hi @Ubaid Eusuf Zai - based on what you said, I would recommend learning more about low-code development. These tools are intended to help users without an IT/Computer Science background to automate tasks in Jira and and Confluence, and even more powerfully, connect those tools to other applications like Microsoft Office,…

For developing applications, and especially regarding Forge, you really should be asking in the Atlassian Developer Community. That being said, there's some documentation here: * Webhook * Issue comments 

If it were me, I'd grab a copy of Bob Swift's Jira CLI and then run commands that look something like this: acli -a runFromUserList --group "Group 1" --common "--action addUserToGroup --userId \"@userKey@\" --group \"Consolidated Group\"" acli -a runFromUserList --group "Group 2" --common "--action addUserToGroup --userId…

Hrm, this seems like it might be useful for "downloading" the file from another issue. The question is how to then "upload" it as an attachment to the new issue: * Downloading issue attachment in scriptrunner cloud I guess perhaps you would somehow combine it with the previous post: * SOLVED: attach a file using REST from…

Ah, a related answer from the esteemed @Jack Brickey suggests you might be able to do something with a ScriptRunner post-function. I usually run away screaming from Groovy, but I found this article that does make it look possible: SOLVED: attach a file using REST from scriptrunner The big question in my mind is whether…

Unfortunately there is not a function to add attachments from within Automation. That is, you cannot add an attachment to your rule itself to then attach to issues. That would be pretty handy, but probably a nightmare to architect. Anyways, yeah even though this documentation says: You can copy attachments by selecting the…

I think you might really need to ask this in the Atlassian Developer Community. I found a related discussion here: JQL find all issues that have a custom property (no matter what content) With this solution: Indeed, the problem is that extractions on arrays of objects are not possible. I don’t know what it is you’re trying…

I was thinking that the trickiest part of any solution here is trying to "link" a particular Confluence page to a particular Google Calendar event. So, I was messing around intending to see if there was an easy way to "copy/paste" a Google Calendar event into a Confluence page (NOPE), and I found a 1-on-1 Meeting template…

I'm pretty sure Google Calendar does not allow dynamic content in descriptions. https://developers.google.com/calendar/api/v3/reference/events I wondered if you could use something like Zapier to accomplish this. I was able to put together a rudimentary automation where if a page is created (alas it doesn't appear that…

Hi Bill - yep, I wanted the listing to be separated by Components, so there would be a section for Netsuite issues, another section for Workday issues, and so on. Ah well... just wanted to spitball it. Thanks!

To use a scheduled trigger to copy a specific page, you'll need to use a CQL condition. Weirdly CQL doesn't let you specify a Page ID (which would be the most foolproof method), so you have to do something like: space=HELP and title="YOUR PAGE TITLE" And ugh, yeah, it looks like the Copy page action does *not* give you an…