Darryl Lee Community Champion

Hi @Kate - It's kind of a weird syntax, but playing around with "To date with time conversion" I came up with this: {{now.withHour(17).withMinute(0).withSecond(0)}} Which returned: 2023-07-04T17:00:00.0+0000 Which hrm, that's 5PM tomorrow, since it's not my time zone. So I then added my time zone:…

Hello @Martin Rodriguez - If you can screenshots of what you've tried and any error messages, that's helpful for troubleshooting. But for a good tutorial on how to connect Automation to the REST API (including a little more details about the authentication and encoding bit, which is a bit of a hassle), I would recommend…

Hi @Leandro Santos - Sure, this could be done with something like this: * Trigger: When issue is created * Condition: Would this be for all issue types? All components? All projects? You would put those limits here * Action: Edit the issue* Update your End Date field to be the {{issue.created}} date plus however many days.…

Nice! OH! You just solved a problem I was trying to figure out a few weeks ago: * Conditional Formatting of Issue List Actually, now that I read @Bill Sheboy's response more closely, that's exactly what he was suggesting (DOH). And yeah, I was trying to avoid having to replicate the block for EVERY component. But maybe…

Ah, thanks @Mark Segall - that's not quite right but it got me on the correct path. this works: {{#issues}} {{#if (labels.match("(STAGING-APPROVAL)").size.gt(0))}} * <strong><a href="{{url}}">{{key}} - {{summary}}</a></strong> <strong>* Description:</strong> {{description}} {{/}} {{/}} One minor note: My JQL didn't initial…

Ohey @Tom Scoggin - similar to this answer the problem is that when filtering lists (or Atlassian calls it, conditional logic), smart values within the filters are always relative to the list. So this should work: {{#issues}} {{#if (equals(labels, "STAGING-APPROVAL"))}} * <strong><a href="{{url}}">{{key}} -…

@Angela Salunga Because I'm a glutton for punishment, I feel like you could maybe get the values into Smart Values using the Automation for Jira - Send web request using Jira REST API trick, BUT I would bet that User Inputs probably does not support using Smart Values for the options. OH, and nevermind because you can't…

Somebody else came up with a fix since the CQL IF Condition appears to be broken: Instead use a Smart Value in Advanced compare condition:

A friend informed me about this open bug, which um, is still unresolved. * AUTO-699 - Using CQL in "If / else block" conditions doesn't always work So... that's fun. My recommendation would be to file a Support ticket, and then add it to that bug.

Hi @Cindy Vel - Maybe check your Usage to see if you've exceeded the number of Executions for your tier? https://YOURSITE.atlassian.net/jira/settings/automation#/tab/usage 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…

Hey @Chris K - I'd be interested in your script. Last I checked there still was not an official way to get a full listing of all organization users. Are you using the workarounds in the still unresolved JRACLOUD-72942 - REST API endpoint to export all users to CSV?

Hi @Hellen Braun -- we should probably ask are you running on Jira Cloud or Server/Data Center? If you are on Cloud, then what @Bill Sheboy points out is correct, and you CANNOT use a username (example: darryllee) to set the Reporter. You would need to follow the example I linked to, which is almost exactly what you are…

Hey there! You're very close! The trick with filters/conditional logic is that the smart values within them they are always relative to the list you are filtering. So what you want is: {{#webhookResponse.body}} {{#if(equals(overdue, true))}} Version {{name}} needs to be released {{/}} {{/}} (I also threw {{name}} in there…

@[deleted] - I'm sorry if you think I am working from a script (or some automation?). I absolutely write every post of mine off the top of my head. My point of tagging you was to acknowledge that you had a bad experience with certifications. I personally am not big on any form of certification, as I don't feel like it…

While I did not have such a poor experience with certifications as @[deleted] I think most of here are in agreement that pursuing certifications will probably not really help your particular situation. Certification tests get into some very specific information, sometimes talk about edge cases, and are expensive. If it's…

Welcome @Barbara Johnson Just to echo what others are saying here, almost everything I learned about Jira, I learned on the job. Their documentation is... pretty good. And they have this really supportive Community of users now. (Actually there was always a supportive Community but with the forums it's a lot easier to…

Re: the REST API, it's a bit complicated, but do-able and documented here: * Populate a user picker field from the description field 

Hi @David Garrett - You actually can use a smart value in a Single Select custom field. It's just the UI is a little... fiddly. You have to type {{yourvalue... into the field, and it will pop an option: Smart value '{{yourvalue...' Let us know if that doesn't work for you!

Hi @Michelle Gronwold - #1 (Edited - I found the answer in an link I missed earlier): No. * MIG-1044 - Migrate filter subscriptions JCMA currently does not include filter subscriptions in it's migration and they need to be recreated manually post-migration. For #2, I'm reading that admins should be able to delete private…

Hi @Kalyan Sattaluri - whoa, you found a rare case of Bill being wrong (albeit on a post from almost a year ago). :-} Smart list filtering (or as Atlassian calls it Conditional Logic) definitely works on DC/Server. I have a rule that uses it on our Jira Server (yes I know) instance. I created it back in March of this year.…

Hi @Chayoung Kim - @John Funk correctly points out that there is a Bulk Change function in Filter view that allows you to set the same value for some set of issues. So if all 100 issues need to have the label 'abc' added, then you should be set. However my first thought when I read your question is that maybe you needed to…

Hi @suren Unfortunately I don't believe there's a way to restrict the field values, even with an add-on. (Behaviours has the "Manage field options" action available in DC/Server, but not Cloud.) I think the best you could do is add a Description to the Fields telling what values are valid for the Instance type, and then…

Hey, thanks @Nathan Waters - AppsPlus ! Exciting to get to talk to the developer directly. Oooh man, looking at the data, I feel like I'm so close to not having to grab your app's metadata every single page. IF ONLY I could do a CQL query for: appsplusBrokenLinksHostnames > 0 OR appsplusBrokenLinksHostnames NOT EMPTY OR…

Oh duh. Entity properties can be queried in CQL. So, yeah, if you installed this add-on, you could then do a query like this:…

If you do install this app, it adds uses entity properties to add a very useful array of links for each page: So with this app installed, it would be at least a little easier to get those links. I haven't figured out where they store the index of pages with links. If we can find that, it'd be a lot easier than having grab…

Oh, I found an add-on that finds Broken Links, and I noticed it shows hosts for all outbound links. But alas, only links for broken ones. Maybe you could ask them to add a feature to optionally show unbroken links too? * Broken Links+ for Confluence 

It does allow for Grouping by Label:

Hi @[deleted] I found this in the marketplace: * Data Tables for Confluence It's able to add a table to pages that includes a Labels column. Unfortunately it doesn't seem to allow for filtering by label, unlike the built-in Attachments List macro.

Oooh, cool question. At first I was thinking there wouldn't be a way to do this without crawling the entire site and looking at the content of every page. But then I remembered that looking at Page Information for a page has a section called "Outbound Links" ALAS, poking around while loading the page, I unfortunately…

OH, I found this great recipe that demonstrates why this is SO HARD: 4.18. Reformat Names From “FirstName LastName” to “LastName, FirstName” I tried to fit this into your use case: submitted by (.+?) ([^\s,]+)(,? (?:[JS]r\.?|III?|IV))? : And it works similarly to my take, and also fails on Esq., but you could certainly add…