Testing for Duplicate Summaries when Creating JIRA Issues with ScriptRunner

I once had the request to add a bit of business logic to a project configuration.  The customer had a JIRA project which contained parts (a bit like a CMDB) and he wanted to avoid duplicate entries. I decided to write a simple scripted validator (using the Scriptrunner).  The code had to take into account that […]

Effortlessly Embedding HTML Forms in Confluence Pages

Introduction A customer called with the following problem “Hi Idalko I need to create a very simple form which collects some data from the user, do some calculation on it and show the result in the same page. Is this possible in Confluence?” The customer was wondering how to create an HTML form in Confluence. […]

Streamlining JIRA Instance: How to Extract Commercial Add-Ons

Introduction Today I had to update a zillion licenses of commercial add-ons in different instances. As being a lazy consultant who likes to use a command line instead of a mouse, I decided to check if I could use the UPM REST API to extract the information. Ingredients for this recipe are a computer capable […]

How to Calculate Days between Issue Creation and Resolution Date in JIRA

Introduction Assume you want to watch how long it takes (on average) to resolve issues. JIRA is providing quite a number of reporting options like the Control chart report and much more. But these are pretty complex things to grasp, and in the end, you just need to know how many days it took to […]

Use Case: Updating Host File with IP Addresses of Host-Running Containers

Introduction We are using BIRT extensively for reporting from our Atlassian JIRA.  The BIRT viewer is a tomcat application that will use a design file to turn raw data into documents or pdf files. But now we have this idea to migrate our Atlassian stack to docker, and the migration of BIRT into the container […]

Use Case: Adding Project Role Users as Watchers to an Issue

One of our customers wanted to adapt their issue workflow such that specific users got automatically added as watchers to an issue when it gets created. The following script will iterate over all users who have the role ‘ProjectWatcher’ and automatically be added as a watcher. /* ** Add watchers from project role ‘ProjectWatcher ** […]

Maximizing Efficiency: Querying JIRA for Confluence Links Made Easy

I had a question from one of our table grid editor customers that I wanted to share, as it’s valuable. They have a nice use case where they wanted to list all comments of a confluence page related to an issue, in the issue itself. The table grid editor allows to query of any relational […]

Optimize your JIRA approval process with ScriptRunner and Groovy scripting.

Introduction Are you considering using JIRA to support an approval process, but you’re not sure how to tackle it?  This page details an implementation we made for one of our customers using a bit of groovy scripting and the unbelievable essential ScriptRunner from Adaptavist. The environment This customer is one of these robust financial organizations […]