David Nickell Expert

how about this :-) .... Review of Atlassian Trends The component that received the most suggestions submitted (jira.atlassian. com) was in the Area of Jira Administration. The Plugin Category with the most iaddons in the Marketplace is Integration. In that category, Github is the most installed at 157,000

This is some great information and kudos to you for pointing out the availability of the REST APIs. I glanced at your plugin in the marketplace and it seems robust and priced very fairly. For anyone wanting more information on using the REST APIs through Power Query (to PowerBI and Excel), let me know. This is a link to a…

That I don't know; Back when I managed a Server Install, I could change the email templates extensively at the code level. If you are trying to make sure the assignee's manager gets a list (by putting them as a cc), you may want to set that up as a second filter and subscription to just the manager, and including just the…

I would guess it is one of two things: * I believe the search endpoint is a GET not a POST (otherwise it wouldn't work in the browser) * The format of your authorization .. When I make my calls from Power Query, the Authorization header looks like what I have pasted below. * The really long string is Base64 encoded of my…

Hello. Not meaning to be arguementative -- just helpful and learning myself. By using the recipients drop-down you can send the filter results per individual so they only get their tickets. I did a double check with ChatGPT and here are the directions. This assumes you are an admin: Create a saved filter with JQL like:j…

you are welcome.... it says "you are new here"... if you don't mind, take a moment to accept the answer. it does help my visbility but might also save time for someone else

Use a filter subscription instead and save on those automation executions :-) Find it under filter>details

Good morning. I have an Excel Spreadsheet that executes the REST Call for issue retrieval. You will need to change the parameters to match your site, API Key, JQL, and fields -- but it should give you the structure you are looking for. As you can see in this example, it pulls back 1700+ issues,. It doesn't look like I can…

I will admit to only scanning over the requirements... but this sounds like a filter subscription solution as a start. Are you familiar with those? Simply put - you create the filter with the criteria you want, establish a "CRON" like scheduled (found under Filter>Details), and pick a group to recieve an email.

Hello Peter - I'll withdraw my comment. I apologize for the confusion

I am pretty sure you are using your version name and not version id. You can check for the right version ids by running this simple REST call in your browser: https://your.atlasssian.net/rest/api/3/project/PKey/versions Here is what the Output looks like when I run…

There are multiple links within the atlassian developer pages. I assume you have looked here? https://developer.atlassian.com/cloud/jira/software/about-the-javascript-api/ If the Postman Libraries or swagger documention will help, there is a link at the top right of each REST API Webpage:

@JZD - Try running this REST Endpoint in a browser: /rest/agile/1.0/board. It should give you all the boards in your instance. (Projects --> Boards ---> Sprints). Be sure the board your sprint is associated to is located with your project.

if your sprint name is the same in two different projects, you will encouter weirdness like this. Use Sprint Names that are disctinct by projects.

I don't think I have a complete answer for you, but I can hopefully get you started. * As you say, these are portal only customers. * Portals provide the ability to allow for organization access. * Users with the right domain can self register in the portal (there are settings for establishing organization - customer…

what about the version (Old School -- aka me) that just combined your working queries? You could also save each of the three as separate filters and then use the filter IDs in JQL

Way to stay on task! So, it should be as simple as combining the 3 working queries with "OR" (project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND status = "Completed" OR issueFunction in subtasksOf("status != Completed") AND sprint in openSprints()) OR (project = CDP AND…

I don't do scriptrunner - but how can something be both an issueType in (Story, Defect, Task) AND subtask of anything? I think you mean OR.... you re look for non completed tasks as well as non complete subtasks (I think). That is techically an "OR". Be sure to use proper parenthesis as well . Myabe like this?: project =…

I do have an idea .... I've created custom fields (wiki style text) for this exact challenge. Many times I will call it "executive summary" or similar. Since it is a single field on the form, it becomes easy to include that field in a status report (export of an issue navigator for example). Happy reporting!

Boards are driven by Filters. If you copied a board, go to the configuration to find the filter being used (right now I think it will be the same filter on the Production and Test board). * Create a new filter (Test) to pull from your test project * Be sure to give visibility to the new filter with the people who have…

Altering my earlier comment ... in this instance, work item is the same as an issue. Per my friend ChatGPT .. "Using the asynchronous Export CSV feature” This refers to a newer, more scalable CSV export method that processes in the background. With this method, you can now export up to 10,000 issues (a.k.a. work items) in…

hope this helps.... I don't use a connector, but here are some related REST API calls. The instance in a rest call looks like this: https://splitdimedata.atlassian.net/rest/api/3/component/10011 Using the jira.atlassian data for an example -- here are some REST calls. (Enterprise uses version 2 of some of the same REST…

Thanks and I have (for my education) witnessed the limit still at 1,000 in the API. If you think my comment might confuse someone, I (or I assume you) can delete it . Thanks for the info.

I don't use the Excel add in so consider this speculation. I just saw a post that said you could now export 10,000 issues - not 1,000 like before. I don't know if that impacted the add-in, but if there were a release for the 10,000 limit -- you may want to look at the content of the release to see if anything impacted the…

I remember as a Project Manager back "in the day", how the 1,000 item limit would occasionally impact the way we had to pull issues out for excel and other purposes. Once I figured out how to paginate with the API's, I was able to work without any problems. I mention this in the event any other API users built reporting or…

Hello --- * A disclaimer -- I do a lot of reporting through Power BI (and some excel) outside of Jira. This gives me the flexibility to format things they way I need. * The comments so far are correct-- these standard Jira fields have time in UTC format down to the second. * I don't know if you can parse the datetime…

Here is some practical advice (I hope) from someone who has been a ling time administrator (not an employee of Atlassian). * Consider Projects as Project Containers. * This year I've seen:* Clients using Projects to Contain all the work by customer (This client did electrical engineering. They had several customer…

This is a little bit out of my league -- but here are some observations. * I make tons of REST calls from Power BI. For applications that are CLOUD hosted like yours, I've been using Authorization=Basic Base_64_Encoded_API_Key * I get the encoded API Key by encoding my user id + my API Token * This works for all APIs -…

I believe it will take a JIRA ADMINISTRATOR to do this (I do not know if a PROJECT ADMINISTRATOR can do it) Nikola is correct but let me expand (and I am a picture guy). * A Project has Issue Types (Enhancements and Bugs for example) * The Project + IssueType has up to 3 screens tied to it (Create, View, Update) * These…

* I think labels is the "low hanging fruit" as they say -- You should be able to click on the label "1.1.44" (any any issue) to get all those issues in a navigator. Then add the new 1.2.50 label using bulk update. But before you go too fast ..... * If all the issues that are a problem have that 1.1.44 label on them ---…