David Nickell Expert

Have you tried the rest API? https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-watchers/#api-rest-api-3-issue-issueidorkey-watchers-delete

* This REST API call will do it. You can paste this in a browser to see what the results will look like. yoursite/rest/api/3/issue/issueKey/worklog * Document is here: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs/#api-rest-api-3-issue-issueidorkey-worklog-get * Here is the power…

That makes sense, and your replies later in this thread help show that you aren’t “afraid“ of the API. it just struck me that there have been a few posts that complain about the automation limit. And of course the API is Atlassian as well. And I guess the benefit of the API as you pointed out later is the ability to touch…

You will have to forgive me as this may not be the place, but I administered many JIRA installs in the past and didn't have automation available to us (beyond some things embedded in the workflows). Are there ways of automating outside of the embedded automation? We used to do some tasks based on DB triggers but of course…

Good afternoon. * Identify the filter for your board * go to your DASHBOARDS Option and create a new Dashboard * Be sure to share the FILTER and DASHBOARD with the appropriate scope of people. (I tend to SHARE with people already access to the project) * And my screen shows a common mistake -- be sure to "add" the…

I don;t have much to add other than to say : 1. Check the expiration of your token -- especially if you were working before and didn't make any changes. and 2. don't let a working "GET" call lull you into a sense that you have your token set up correctly. I've seen REST GET calls work when my token handling was wrong only…

Yes. I use this: myuyrl /rest/api/content/search?cql="CQL_Query"&expand=history.lastUpdated,version,space,container&limit=500 Where CQL_Query = lastModified>="2023-09-01" and type=page in Power BI -- it looks like this:

Am I misunderstanding? You can log work anytime you want. You don't have to track it and then update it when the ticket is complete. You can add time on the fly:

This one is difficult to answer without actually tinkering with the JQL to see the results in action. That said, A. >> If you have an "OR" in your JQL, be sure to surround the different conditions with Parenthesis. * project = <Project ID> AND component = WEB-UXD OR (labels = WEB-UXD) * is very different from * project =…

This is a pure guess, but based on what you have provided, it sounds like maybe the Dev Manager name changed? (We ran into this previously when an employee changed their gender). I honestly don't think we ever fixed it because the name is tied to a user id which is further wrapped up in connectivity to Single Sign-on, user…

Yes. At my last employer, we had a PROJECT for our legacy application. Enhancements and Maintenance items were handled on a SCRUM board (with two week sprints). Bugs and questions were handled on a KANBAN board when developers had spare time. Boards are driven by filters. So it is entirely possible to have multiple boards…

It's a bit of a "hack", but it is something I used to do during capacity planning (and status reports). That is, export a list of EPICs into one Excel Worksheet and then Export a list of stories that includes the EPIC LINK into a second. Then in Excel it is a matter of doing a "CountIf" in the first sheet to get the number…

:-) on using ChatGPT. I do it as well. This may be more involved than you want, but since you tried some Python scripting I think you'll enjoy it. Try the REST API Changelog. (REST API + Power BI is my go to answer for almost everything data analysis related), In this screen shot, I show the Priority Field as an example.…

Can you provide a screenshot of your gadget preview and resulting page? Are you getting an error? Is anything at all displaying?

I agree with what @Walter Buggenhout said in his response but when I read your question I thought you meant you were unable to see the resolution field. 2 things... (1) Resolution has to be present on the fields of the view screen. I just check my own install and Resolution IS NOT on the default screen out of the box from…

Hello -- since boards are driven by filters, can you view your filter on the issue navigator? (you should be able to get the filter name/id from your board configuration). You may have a condition where you are returning too many issues.

I don't follow your need completely but that may be due to a lack of caffeine on my part ;-). The use of Components may be the magic you are looking for. * Assuming your organization produces software applications, your application can be broken into Componets. * You can use Confluence to hold requirements, test cases,…

The APIs can be cobbled together to do a variety of tasks. Here are two use cases I've had in the past few years: * NAVIGATION and MONITORING: I started new with an organization where the documentation had grown to "hard to manage and navigate" levels. No one, for example, could point to the most updated technical docs for…

Hello and thanks for the response. I didn't have time yesterday, but spent about an hour today doing most of the work. I still need to add the datediff logic to know the actual amount of time per status. Then as you can imagine with a little bit of analysis we could determine which statuses were generally taking the most…

The REST APIs URLS are case sensitive. I think your problem is the categoryID should be categoryId. this worked as expected for me: https://ecosystem.atlassian.net/rest/api/3/project/search?categoryId=10070 And I only know this from pulling my hair out multiple times by making this very same mistake.

I know there has been a plugin recommended and that very well might be your best alternative. I think it depends on your audience and features you want. With that disclaimer in mind, I will point out there are REST API calls for getting the Changelogs (and transitions) for an issue. If your needs are simple and your…

interesting... I thought completed was driven by the Resolution being set. And in some cases, a Resolution could be Cancelled which I sometimes wouldn't even show on the board. That triggers the thought some users may not know that Status and Resolution are different concepts. I'm not saying you are wrong. I am just trying…

A recurring issue I've seen at multiple clients is when Sprint Names in project "x" are the same as the Sprint Names in project "y". I don't know if that is your issue, but Agile was originally a plugin called Greenhopper with its own data tables (just like other plugins had), If your board has a Sprint name that is also…

if you are willing to use the REST API, its a matter of using the GET endpoint for an issue that includes the worklog. So for example: https://jira.atlassian.com/rest/api/2/issue/JRACLOUD-31024/worklog tells you this (when you visualize the resulting JSON

My "go-to" answer to most JIRA reporting or data question will likely have 3 parts: * Start with a filter. I've set up an example against jira.atlassian.com and pulled all the tickets out for five projects over the last 5 years. The JQL looks like this: project in (CLOUD, AUTO, CONFCLOUD, JRACLOUD, JSWCLOUD) AND…

Sorry for any confusion. If I understand the issue, your personal board is "trapped" inside an organization you no longer work for. You can't log in and you can't retrieve a reset email Altassian is trying to send you. In an earlier post today, someone was asking for details about one of their boards. I was stunned that I…

I was just looking at a different Trello question in another post... and I'm a big believer of using the Atlassian APIs. Try plugging the organization name into this url to see if you can access the list of boards through REST: https://api.trello.com/1/organizations/ORGNAME/boards If that works, you may be able to walk the…

This is a bit of an educated guess since I don't have Trello and have never been an administrator for it. But the REST API documentation here: https://developer.atlassian.com/cloud/trello/rest/api-group-boards/#api-boards-id-memberships-get Indicates there is an OrgMemberType field that may give you the answer. With only…

It almost sounds like your text field should be a custom label field instead. This makes more sense if the Customer Reference is either a number or some simple text. * The label field has type ahead so once a label has been added once, the next issue will have access to the same value. * Labels cross projects whereas other…

This is a bit of a "guess" on my part -- but when you define a filter you have the option of using your default column layout or a filter specific one. I can see from your URL that you are using a filter but also modifying some of the criteria, Try: * Make sure your filter has its own column order defined. That can be…