The amazing new features of eazyBI 6.4 !!

The new version of eazyBI 6.4 provides us with new functionalities that can be very useful and that we want to highlight in this post, such as: Conditional formatting on bar, line, and timeline charts.!! (here more info) Use conditional formatting in charts (bar, line, timeline) to highlight individual bars, ranges, scatters, or bubbles. 2.…

Read More

Set Due Date (or Date-Time customfield) in Jira Cloud using Postfunction of Scriptrunner (Part II: Working days)

This post is the continuation of: Set Due Date in Jira Cloud using Postfunction of Scriptrunner To evolve the script, to put for example Working days instead of natural days, when setting a due date can be somewhat difficult using Scriptrunner for Jira Cloud, the reason is that we cannot use “while” loops, we must optimize…

Read More

How to fix error in panel Issues in Epic: An exception occured while rendering the web panel: com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel (null)

Hello visitor, If you are expereincing this error: Probably exist a corrupted linked issue in this Epic. Atlassian recommneds to fix it, do operations with SQL, but that is NOT my recommendation: https://confluence.atlassian.com/jirakb/issue-screen-displays-error-rendering-greenhopper-epics-issue-web-panel-in-jira-server-779158857.html Probably the better solution is to run a little Groovy Script in Scriptrunner using the “Script Console” to run just one time!…

Read More

Create Confluence Cloud spaces from Jira Cloud Workflow Postfunction (with Scriptrunner)

First of all, create a new API Key Token: Create an API key: https://id.atlassian.com/manage/api-tokens# Combine the key with login name in base64 string, go to https://www.base64encode.org/  Format is loginname:API-key exampel: email@email.com:ABCDE12345 give result: a3Jpc3Rlci5icm9tYW5AYWR2YW5pYS5zZTpBQkNERTEyMzQ1 Combine this with the authentication type in the below case a basic so the full text is: Basic a3Jpc3Rlci5icm9tYW5AYWR2YW5pYS5zZTpBQkNERTEyMzQ1  Now we are ready to create the…

Read More

How to configure SSL MySQL for Jira Server and Confluence Server

To connect Jira & Confluence using SSL with MySQL we need to download the MySQL certificates. Once downloaded (mysql-server-cert.pem, client-cert.pem and client-key.pem), we need to convert to a keystore format to be imported in Java when the services are started. How to convert the MySQL certificates and store it in Jira & Confluence? Using “Keytool”…

Read More