David Nickell Expert

Answer #2 :-) There are different levels or types of Admins. There is some good documentation here: https://support.atlassian.com/user-management/docs/give-users-admin-permissions/ Consider a use case where your Jira Admin may need to be restricted from sensitive information like HR detail. It sounds like you need to be a…

This looks like a good way to go. Bulk Edit (move, etc) is magical. Here is a link to some documentation https://support.atlassian.com/jira-software-cloud/docs/change-the-issue-type-for-multiple-issues/

My answers normally start off with some API based trick. Not this time. I've never seen this docimentation so I'd suggest starting here. Looks like good stuff and if you can't do some of what it suggests, you probably aren't an admin (or don't have premium conflunce - which appears to be require for this specific feature)…

Greetings all. I'd like to challenge (in an intellectual, fun way) an automation approach when compared to the filter subscription approach * The Filter Subscription solution will let you see the list of impacted tickets (though you have to create copies of the JQL that don't include the current user piece). * Along those…

You may be doing everything perfectly and may not realize that no matter how hard you try, Excel does something to alter your data when the file is saved. Open the file in a good text editor and see if you can spot an issue. I don't even recall what tripped me up before... but I finally corrected the CSV format using TEXT,…

I did an video the other day... see if this answers your question. And if it doesn't, please let me know that as well. https://www.youtube.com/watch?v=VHG9tUei9Xc Note: This technique gets the token. That still has to be combined with your userid and colon to be a valid API Key. If you need a Ready to Use Key for an Auth…

* I did some research and if you enabled Story Point estimates after your item existed, I think your blocked. Try creating a new issue. * Or, the story point field isn't on your edit screen. hopefully one of these two will fix it

Hello. how to do automated emails comes up on a regular basis and my go to answer (for 15+ years) has been to use a filter subscription. You can find documentaion on Subscriptions here: https://support.atlassian.com/jira-software-cloud/docs/manage-filters/#Create-an-email-subscription-for-a-filter Your situation has two…

I appreciate the feedback. Be sure to check out some free REST API tools I mention on my website SplitDimeData.com. You might find you can do a lot without plugins

Good evening. I have long stated that JIRA can be self documenting by using the REST APIs as @Mohanraj Thangamuthu suggests. The problem is REST APIs can be complicated and if your job is producing widgets, you may not have time to write API Calls.... Last night in the community I "finally" put a downloadable version of my…

I may be able to add something to the discussion. This link is to a marketplace report I've been tinkering with for a couple of years. It shows plugins by category along with changes in install counts since April.…

I don't have a definitive answer for you, but here are some things you might consider: * If you have a premium license, the plan view filtering and repoting capabilities might let you see the universe of tickets you want. * Or, maybe you could use an automation rule to update a flag at the Epic level when a Story Moves…

when you're ready to grab the non-changing records and set them aside to save time with future extracts, let me know. There are JQL statements we can use like last updatedDates and./or resolutions to establish your archive. You wold use the REST API to grab the new records and once you have those, we'd merge with your…

Yes -- you can use any JQL or Filter. you may find it easier to run the JQL in the Issue Navigator first, then simply paste into the Excel Parameter

Check to see if someone created a custom field called "Priority". This happens all too frequently -- that someone doesn't like the priority options and end up creatring a second field not realizing thet confusion that might occur. you can run this REST endpoint in your browser if that helps to confirm which fields exist:…

I just ran this in the ecosystem instance (cloud based) without any issues. Maybe I don't understand what an "Issue History" search is? Are you running a query from some place other than the issue navigator ?.

I have done something like this for a client previously using the REST API and Power BI (I've done this kind of thing "on-premise" and "cloud" before -- but admittedly not Data Center) Once you have the worklog data, if you are willing to use Power Bi (or some other BI Tool), you should be able to slice/dice/aggregate all…

Here is a YouTube for the actual extract process https://youtu.be/EP-VJRzrdrg?si=6neEWnZFLJN4gJcG

here is a YouTube Video I perepared on creating an API Token https://youtu.be/VHG9tUei9Xc 

Hello -- the excel download can be found here: https://splitdimedata.com/downloads The Excel File is at the bottom of the page. I don't want to "junk up" this thread with details, so I will publish a PDF of instructions shortly along with a YouTube video (where comments and collaboration are welcome). Some quick points: *…

IMHO * Data Access outside of Atlassian begins with the REST APIs. They are free. * Then you can apply your favorite tool. For me, it is Power BI. I know this is a cryptic answer, but it's a complex topic. This is not a sales pitch. But here are some examples of Power BI Reports built on the APIs. Thanks Here is a REST…

From what I can tell - you are correct that the "Team" field is a special type. Its not a string or an ID ... its a Team What I don't know is whether that means its what the REST Documentation is calling a "plan only team" (though I suspect it is). Check this documentation.…

I've adopted two "terms" which may or may not be official/accurate: * an API Token is what you get from the profile security link you shared * an API Key is what happens when you encode your userid, a colon, and the API Token you were provided. Authentication occurs when you put "Basic <your key>" in an Authorization…

So -- Success (so far). In the ecosystem.atlassian.net, I can see 58,414 issues which is what my Excel Power Query is also returning. I was also surprised at the speed -- under 10 minutes (which includes date formatting etc). I'll spend some time polishing up some instructions and as promised, will post a link before…

Cool—- I’m away from my desk but will post a link later tonight 

Are you willing to use the REST API and Power Query to pull your data into Excel? If so, let me know and I will add a link where you can download the tool I built (free). All you need is a URL, and API key, and the filter id, and the fields. Its the same code (literally the exact same code) I use in Power BI... Power BI…

Maybe I am the only one confused -- is this a Jira Report? A Trello Report? maybe you could add a screenshot? I 'm asking because a few months ago, the API for Jira Work Item Data changed which tripped up several people who were extracting Jira data. If your problem is related to that, I (and many others) may be able to…

priority was in (P1, P2) Thats the JQL Enjoy

You can use the rest API to pull your results into Excel. I haven't done this specific set of REST calls yet (I've done a bunch), but here are the steps: The Atlassian Piece (REST) this call gets all the labels you have (in the event you need a list and/or need the ids)…

Power BI is not free. It has its own licensing and infrastructure (as would any Commercial Tool). Many clients already have Power BI in place for their Business Intelligence needs which makes adding JIRA into the tool a pretty easy decision. Power BI is inexpensive (IMHO) and of course, Excel is practically free. But I'm…