Darryl Lee Community Champion

So, if I correctly understand the requirements: * IF parent issue not updated in last 7 days * AND subtask status = IN PROCESS * THEN send a notification to... the subtask assignee? With these assumptions: * Only one subtask will ever been IN PROCESS at a time. * If there are more than one subtasks IN PROCESS, then the…

Can you take a screenshot of what the values you're trying to set during the Edit action (Berwerken? Hey I learned some Dutch!)

Sure - if you create a chart in Google Sheet that points always at the same dataset (the sheet of Jira results), then the chart should automatically update whenever the scheduled import of data happens through the Google Cloud for Sheets add-on. I think the best thing to do here is to play with it, and if you have…

Oh hey, yeah, you can totally reduce the number of fields that the add-on imports from Jira. You could do that in Jira first, by clicking on Columns. In my screenshot below, you'll see that I've named my filter "Minimal", and then only selected the fields Created, Status, and Summary. When I then click "Open in Google…

Hi Andrew - are you talking about using Jira Cloud with Google Sheets? To confirm, that would be this add-on for Google Sheets, right? https://gsuite.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016 I just installed it and it looks like you ought to be able to Schedule a regular import of a JQL query. From…

Hey @Bob Sellers , I've heard bits and pieces about Power Automate. That's Microsoft's version of IFTTT/Zapier, yes? How do you like it? Would love if you can share how you got things working with Jira. Thanks!

You make a good point, @Monique vdB To be fair, my childhood zoo was the Oakland Zoo, which in 1983 was listed as one of the 10 worst zoos by the Humane Society of the US. :-{ So when we brought our kids there 10 years ago, I was pleasantly surprised with the turnaround they'd made [even though they still had not yet…

So, I'll be honest. I'm not big on zoos. But this one time, at a company picnic, they hosted a petting zoo. So I don't have to drive to the zoo and see caged animals that are sometimes smelly? Ok, that's cool. I found this photo in my Google Photos archive when I searched for 'zoo'. A Google Lens search tells me it's…

Ohai. Am I posting here just to get badges? Well.... maybe. I mean, who doesn't love swag? (Sigh, I miss Summits.) In researching what to write in this post, I realized that I've been working with Confluence and Jira since at least... 2008. Wow, that's dating myself. I found an old email telling my manager that I was going…

Oh hey, I was visiting from San Jose, CA, and at the end I recalled somebody had a question about transferring Attachments from Server/DC to Cloud while preserving metadata. I remembered but didn't have time to lookup a recent question I read about Cloud to Cloud attachment transfers, and more specifically a…

Oh hi, - I really appreciated the New cloud apps roundup. Definitely some interesting new Jira apps to investigate.

I had thought to use the Lookup issues action and just populate the trigger issue's fields with something like: {{lookupIssues.firstname.first}} But... From the resulting issue list, the following issue properties are available to use (custom fields aren't available): Drat. I'm stuck again. Any other ideas Bill? You could…

Hey @Bill Sheboy - actually, it looks like Standard users get 500 global or multi-project executions/mo and even Free users get 100/mo. Customers on Free and Standard plans have access to a limited monthly trial allotment of global and multi project rule executions (100 and 500 per month, respectively). Premium users have…

Hi - Based on these filed Suggestions, I don't believe there is a way to check PR approved: https://jira.atlassian.com/browse/JRACLOUD-71798 https://jira.atlassian.com/browse/JSWCLOUD-15308 Related questions:…

Oh, hey, there's an API for searching for objects, and I think it may work by name: https://documentation.mindville.com/display/INSCLOUD/REST+API+-+Objects#RESTAPI-Objects-Findobjects(Advanced) Well, that certainly opens up some additional possibilities, maybe using web requests.

@Ravi Sagar _Sparxsys_ that is indeed the right format if you already know the asset ID (in your example 4548_11) you want to add to an issue, but since Stephen's question is about trying to backfill an Insight field based on existing Labels, there's a bit more to it. The problem that I've found in testing is that Insight…

One type of request that occasionally comes up is for manager/executives to see issue/ticket counts, without wanting (or needing) to dive into individual tickets. Or with siloed teams, there's been requests to actively prevent visibility into details while still offering a real-time view of high-level numbers. Has there…

Hi, I think you might need to add a Branch rule (in purple) to target the Parent. Like so:

Hi - I think you'll have/want to use Incoming webhooks: https://confluence.atlassian.com/automation/triggers-993924804.html#Triggers-incomingwebhookIncomingwebhook Incoming webhook * Available in Server Lite: No * Related smart values: {{webhookData}} A webhook is a way for a third party to trigger an Automation Rule. The…

Can you provide a sample of what the issue description might look like? It's hard to debug regexes without the source data. I think the problem is that question mark before the (.*). Question marks usually follow + or * quantifiers to designate that they should be "non-greedy". But assuming "date created:" is on a line by…

I think the only problem is here: * After the issue is created, a rule is triggered to "process" the issue --> the main objective is to extract from the email body (stored in the issue description field), the values of different custom fields. So the trigger is create, and then he'll need to Edit fields based on match…

I'm thinking it's not possible. I had a web request that had a possibility of failing, and I tried to "trap" for unsuccessful requests by checking {{webhookResponse.status}}. It never worked. Alas, upon closer inspection, you only that smart value that if it's successful: On successful webhook execution, you would be able…

In years past, we've visited a local pinball museum/hall that stays open a little past midnight. One price includes unlimited play, and in prior years they also used to have snacks, a limited bar, party hats, raffle prizes, etc. https://www.pacificpinball.org/ This is from 2013:

Oh that's definitely true - if other people have visibility into the rule, they'll be able to see / copy the token, which can be a real issue.

Improvement filed: "Possibility to nest smart values in Automation" https://codebarrel.atlassian.net/browse/AUT-2086 Related questions: https://community.atlassian.com/t5/Jira-Core-questions/Is-there-a-way-to-concatenate-or-nest-smart-values/qaq-p/1374187…

I set a created a variable named changed set to {{changelog}} and then created another variable named changelist and used match() to parse out the list of changed fields: {{changed.match(".*?field='(.+?)', .*?")}} But then I tried to use Advanced Field Editing to set the field values to the parent, and that's where I…

Bah, I could've sworn I wrote up a whole answer involving clever smart value variable manipulation, but in the end, ran into the same old same problem that you can't embed/reference/nest smart values inside of other smart values. I wonder what happened to my answer...

Yeah, but then you have to use ScriptRunner! Kidding. :-} I'm just not great at Groovy. But you make a great point Ravi - if ScriptRunner can provide direct access to the API (without having to generate an API token and use the kinda janky web request action), then surely Automation ought to be able to. C'MON guys, I mean,…

Yeah, I was concerned about this too, but since Atlassian acquired Codebarrel now, I'm *hoping* that the Automation servers are not too many hops away from Atlassian servers, and so our Basic Auth credentials are not being exposed at too many points. To address the issue of tying API calls to a single user, we ended up…

For the record, here's the error I get: Error while rendering additional fields. Failed to get value for issue.parent.{{. So yeah, it doesn't like that. I don't exactly know the right terminology - eval, nested variable, reference variable, pointer variable. But yeah, I have a few automations where I could really could…