JIRA tricks PHP & JIRA REST API PHP - JIRA REST API Script Fragments & REST Scripted Custom Fields

How to create a Jira custom field with options from an external REST API

To do this exercise, we will use the famous plugin for Jira called Adaptavist Scriptrunner. First step, we need to create a REST Endpoint in our Jira Server. This REST Endpoint will query the external REST API to obtain the values and options (In this example we will query GitHub to obtain a list of…

Read More
Books JIRA tricks JQL JQL Custom Functions News

JQL Trick: How to search for labels with a wildcard expression in Jira Server

If your company has installed Adaptavist Scriptrunner you are in luck! You are available to do a search for labels using a wildcard expression using JQL You can use the JQL function issueFieldMatch Example of usage: issueFunction in issueFieldMatch(“project = JRA”, “labels”, “ie[8|9]”) This will search for tickets with “ie8” and “ie9” labels issueFunction in…

Read More
Confluence tricks Uncategorized

Obtaining Confluence metrics & SQL tricks

MySQL query to get the last login of all members of the confluence-users group SELECT distinct u.lower_user_name, l.successdate FROM cwd_user u LEFT JOIN logininfo l ON u.user_name = l.username JOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN spacepermissions sp ON g.group_name = sp.permgroupname WHERE permtype=’USECONFLUENCE’ order by u.lower_user_name; …

Read More