Jira PowerBI: Automatic renaming of Columns to real field names

I share here how I have improved my Jira PowerBI Template to automatically rename the field columns by the real field names instead of their Ids.

Universal Date Picker with Calendar Week supporting Atlassian Tools (Jira, Confluence,...)

I have shared some time ago a small script for a universal date picker with calendar weeks displayed. Now in Jira and Confluence the date format is fixed to mm/dd/yyyy. Moreover, Confluence has a specific way of formatting dates. So I have adapted the tool to better integrate with Jira and Confluence. 

I share here the result.

Jira Cloud New Issue View and Quick Edit Hide when empty fields (Cloud Regression)

We have recently migrated our Jira from server to the Cloud and today I have hardly missed a feature related to quick edit of fields.

New PowerTool for Atlassian Tools

Let me introduce a new member in the PowerTools family: I have named it "Atlasy". 

It improves UX and productivity with the Atlassian-based tools like Jira, Confluence, R4J.

Jira-Excel Integration for bulk edit based on R4J Excel Plugin

I have presented in the R4J German User Group on 2023-09-20 how we use the R4J Excel Plugin to bridge Jira and Excel.

PowerBI: How to reorder a Legend

I share here a learning about how to reorder a Legend in a PowerBI Chart.

Excel Index Match

I have stumbled recently again upon the Index/Match combo and forgot that the 3rd argument in MATCH is most needed and shall be set to 0.

Jira: Quick Update Epic Link(s)

Post is currently in DRAFT. This post explains how you can quickly link issues in Jira to an Epic using an AutoHotkey script.

AutoHotkey Basic Authentification for REST API e.g. Jira

I have stumbled upon an issue in the b64 encoding function that broke the Basic Authentication when using a longer password e.g. API token.

I share in this post how I do REST API calls with a Basic Authentication example for Jira including the fix for this issue.

Jira Excel VBA Module with Basic functions

I share in this post some examples how to use Jira REST API from Excel VBA. This post is a WIP/Draft. If you are interested in me explaining more, leave a comment.

Jira: Add multiple links using R4J Excel Add-In and VBA macro

I share in this post a way to add multiple links to Jira issues using R4J Excel Add-In and additional VBA macros. This post is a DRAFT/WIP quick version. If you have questions about it, please leave a comment to let me know and I will update it.

Jira: Create multiple issue links by script

This post describes how to bulk add a link to issues in Jira using the API. This a draft/wip version. Comment if you want me to finalize it.

ScriptRunner: Create Comment or Write Text Field with Links

I didn't find any documentation for this one.

I wanted in a ScriptRunner listener to document the action done by the listener with a comment in the impacted issue, with a link in the comment pointing to the user documentation.

You can do this easily by formatting links with [linktext|linkurl]

Here is an example of code for a comment:

commentBody = "[Listener|https://confluenceroot/pages/viewpage.action?pageId=375883539] labelled the issue with 'suspect_mod' because parent issue ${issue.key} had following fields changed while in Status 'Closed':" + commentBody

// flag current issue

def issueManager = ComponentAccessor.getIssueManager()

def user = ComponentAccessor.jiraAuthenticationContext.loggedInUser

def commentManager = ComponentAccessor.getCommentManager()

// Add a comment to issue

commentManager.create(issue, user, commentBody, true)

ScriptRunner: Listener triggered on field change

Wanting to trigger a script upon an issue update and specifically upon changes on specific issue fields is a common use case in Jira. I have learned recently the right way to do it.

ScriptRunner Listener for Suspect flagging

I share in this post how to implement a suspect mechanism in Jira using a ScriptRunner listener.

Jira Workflow Triggered transitions

I share some learnings, concerns I've had recently concerning Jira Workflow triggered transition.

ScriptRunner Listener: Project Blacklist

There is no built-in way in the ScriptRunner UI to define a project blacklist. I share my learning here, how to do this.

Authenticator without mobile phone

I have learned recently a way to have an authenticator not only on my phone but in my browser on my PC - using a password manager extension.

ScriptRunner Listener for IssueLinkCreatedEvent or IssueLinkDeletedEvent: no current issue?

I have struggled a bit with implementing a Link Listener with Jira / Scriptrunner and share my learning here.

Jira Admin: How to order Workflow Transition Buttons

I share in this post how to set the order of the Workflow Transition Buttons in Jira.