Darryl Lee Community Champion

Edited to add tl;dr - here's the answer that I think Lana was looking for when she clarified: If I want to get the sum of “StoryPoints” for all lookup issues where “Create/Update Automated Tests?” is set to “Needed for Release” {{#=}}0{{#lookupIssues}} {{#if(not(Create/Update Automated Tests?.value.startsWith("N")))}} +…

The manual trigger I am using is just for testing. What you need to do is edit your existing rule and insert the 2 "Create variable" actions after your trigger, and then update the Attachments section of your email to use the code I gave you (that includes the "split" commands).

OH! I forgot to mention, it's so annoying but the field ID has to be specified like so: https://YOURSITE.atlassian.net/rest/api/2/field/customfield_10120/context Totally lame - {fieldId} totally sounds like it should be a number.

Hi. I think you may not have fully understood my instructions. It looks like what you included in the email are supposed to be intermediary variables that are later used within the email. So you need to use the Create variable action to create the variables I mentioned, like so: Then you will reference those variables in…

Hi @shardern_kpmg -- To get the Context ID, you need to click on "context(s)" link for your field in the Custom Fields list: Then click on the Create, edit or delete contexts link: And finally, click on Edit context: The "Context ID" will be in the URL of this page as fieldConfigSchemeId, for example:…

Hey Ken - Yes I too was disappointed that Automation only allows you to create an empty page. That doesn't seem particularly useful. As you've found, it looks like the only way to actually create a page with content is to use the API. Here's a few articles on this: From @Elelta D * Make a table on a Confluence page via the…

Hi @Aviel Ovadia -- By default Jira Cloud uses an internal SMTP server, but this means all mails will come from the jira@YOURJIRA.atlassian.net You can configure an alternate email address to send from (like in your own domain), but you'll need to do additional setup to make sure replies are properly processed by Jira.…

Hi @Mustafa Mousa - Can you provide a little more context? Is this part of some kind of build script/automation? Do you want all the attachments if the script is given the input of a single issue key? Or are you trying to do a bulk download of attachments for the whole server or a single project? And have you already tried…

Hey @Martinbill83 - yes, this is expected behavior as part of the default Mail Handler. Jira's default is to only include the "replied" text to eliminate extraneous text in comments. There are a few other options though, as detailed in the documentation for Mail handlers. Jira provides the following default mail handlers:…

Hi - alongside this question in the right-hand nav is a section called Related Community Content. Following one of those links I found a few previous questions with answers and comments that should give you some examples and ideas on how to use startOfWeek()/endOfWeek(): * Exclude weekends in JQL Query * Need filter for…

Ugh. We have 300+ domains. We're just testing our migration. I didn't want to click 300 times, so I generated a list of domains (thanks ScriptRunner) and then ran this cli within a for loop: acli jira --action renderRequest --requestType PUT --request '/rest/migration/latest/email/domain-rules' --requestParameters…

Hi @Gnana Sekhar Reddy will any attached documents not be MOP documents? If they are all MOP docs, then you could just grab the .last attachment: * <a href="{{issue.attachment.last.content}}">{{issue.attachment.last.filename}}</a> But I guess if there might be other documents interspersed amongst the MOP docs. Hrm. This…

Ah @Vamsi Kandala I didn't read the original post clearly enough. You're absolutely right. Hm yeah now I'm interested to see what the problem is. 

Hey @Bill Sheboy - I had to scroll down in @Karoline Rezende Ramos's original screenshot to spot the extra edit down there at the bottom: @Karoline Rezende Ramos I think you're getting the error because this Edit issue field needs to be dragged beneath the "Add comment" block so it is within the "For All created issues".…

Hi @Gergana.Damyanova So first off, you will need a third-party app that allows you to set up a custom Workflow Validator. For example, JMWE includes a Field Required Validator which you would need go add to your Create transition. That's where you would add: user.groups.includes("yourgroup") Similarly, you could use a…

Hi @Gnana Sekhar Reddy -- thank you for including the error message. It was very helpful in finding the problem. The thing that was breaking your rule is that your quotation marks in the match block are “curly quotes”, not "straight" quotes. I replaced the quotes with straight quotes, and it got rid of the error. HOWEVER…

I was able to do this using the olde DVCS Connector (under Integrations), even though it is supposed to go away any day now (they announced deprecation in 2018). I generated a Client Id and Secret by following the directions here: * How to get GitHub Client ID and Client Secret API details? I entered my Jira Cloud…

Also, if it's just a matter of expanding the nested tables automatically in Excel, a colleague who is an expert in Power Query (hi @Michael Rothstein suggested this article: Expand All Columns Dynamically in Power Query 

Hi @Syed Arif When you query the REST API directly you're going to get JSON back. Those aren't tables, but rather structured data that looks like this: "votes": { "self": "https://MYJIRA/rest/api/2/issue/ABC-25250/votes", "votes": 0, "hasVoted": false }, If you really want to use the REST API, I suggest reading @Brendan…

Hi @Gnana Sekhar Reddy - so if you're asking if you can only include a specific file to the email, yes you would simply change the match() statement above to something like: ... .match("(nameofyourfile\.docx)") The \ in front of the . is used because . is a "wildcard" character in regular expressions.

Aw shucks, thanks for the kind words, @Kristján Geir Mathiesen ...

One caveat is that both using SET and COPY appear to add assets to the linked issue, but not REMOVE any. 

Actually now that I've played with it, you probably want to just: Copy YOUR FIELD from Current Issue Like so:

Ah, figured it out, thanks to opening a Support ticket and getting help from @Lucas Silva ! Even though my rule had a manual trigger, it was only scoped for a Single Project, and I guess Automation thought I might be trying to copy it to another project, per this KB article: * How to copy Assets object field values from…

Hi @E Hanumanthu - I think this will do the trick. I had to put it all on one line to avoid Automation adding line breaks in the email: {{#issue.attachment}}{{#if(exists(filename.match("(.*\.docx)$")))}}* <a href="{{content}}">{{filename}}</a> {{/}}{{/}} Basically we are trying to match filenames that end with .docx, and…

What's really odd is that last link is specifically talking about the "new" Assets in JSM, and makes it seem like the easier solution (just doing an Edit issue in Automation) ought to work: But in my testing, I could not see my Asset object custom field available for editing in Automation. @Grady Gausman or @Charlotte…

WELL. This was a journey. As you discovered, @Fabio Manzoni for some reason Asset object custom fields apparently no longer show up in the Edit Fields action. I don't know if this is a change from Insight being an add-on to now being integrated with JSM Premium but for whatever reason, these instructions DO NOT WORK: *…

Hi @Fabio Manzoni -- According to this KB article, there is a separate Automation action for Editing Objects - you don't edit it as a field: Update object attribute values using automation with JSM Assets There's also links to several examples. Hope this helps!

Ah yeah, so Team-managed Projects are... different. I just did a little test, creating a few of them, and what's happening is, even though the Issue Type looks like the same "Task" as any other project, in Team-managed Projects, they are actually all uniquely different issue types. SO THAT is what this error is about:…

Hi @Bill Sheboy and @Kavitha Vasudevan At first I was thinking that if Kavitha just wanted to send simple notifications when users average time logged is not past a certain threshold this could be done with Automation, but I ran into a problem of trying to access Worklog data when you are NOT using a Worklog trigger but…