JQL

Script JQL Functions: Included Functions in Groovy ScriptRunner

JQL functions: hasComments commented lastComment lastUpdated hasAttachments fileAttached workLogged dateCompare hasSubtasks subtasksOf parentsOf hasLinks hasLinkType linkedIssuesOf linkedIssuesOfRecursive linkedIssuesOfRecursiveLimited expression aggregateExpression issueFieldMatch issueFieldExactMatch myProjects recentProjects projectMatch / componentMatch / ver earliestUnreleasedVersionByRelease addedAfterSprintStart removedAfterSprintStart incompleteInSprint completeInSprint nextSprint previousSprint inSprint(board name, sprint name) See more in Adaptavist ScriptRunner

Read More
JIRA tricks

JIRA trick: Set one more category status color! The “undefined color” (black color)

To see one category status color more, you need only: Go to the JIRADB Database Execute SQL: SELECT * FROM jiradb.issuestatus; In the status you need “black color” set the field “STATUSCATEGORY” to 1 That’s all! Supported colors (in the standard) Field Summary Fields Modifier and Type Field and Description static String COMPLETE static String IN_PROGRESS…

Read More
JIRA Plugins / Add-on

Create a new plugin / add-on in JIRA to set custom CSS and Javascript / JS in all pages

Creating our first JIRA plugin “Hello World”: enter in C:\atlastutorial atlas-create-jira-plugin Enter 1 for JIRA 5 groupId: com.atlassian.tutorial artifactId: helloworld version: 1.0-SNAPSHOT package: com.atlassian.tutorial.helloworld Press Y to continue Browse to and open the atlastutorial/helloworld/src/main/resources/atlassian-plugin.xml file Modify helloworld.js and add inside a piece of code like this: “alert(“Hola!”)” Modify the tag <context> to active the Javascript…

Read More
JIRA Plugins / Add-on

Create a new Add-on or Plugin in JIRA to show more options in the Main Menu /General Menu

Creating our first JIRA plugin “Hello World”: enter in C:\atlastutorial atlas-create-jira-plugin Enter 1 for JIRA 5 groupId: com.atlassian.tutorial artifactId: helloworld version: 1.0-SNAPSHOT package: com.atlassian.tutorial.helloworld Press Y to continue Add a module to the plugin: enter in C:\atlastutorial atlas-create-jira-plugin-module Select the 30 Web Section item by entering 30. Answer each question as follows: Question Value Description…

Read More
JQL Other Performance Tricks

One simple way to obtain time measures of JIRA from terminal

The best way is using CURL from command line time curl -D- -u raul.pelaez:*** -X GET -H “Content-Type: application/json” http://127.0.0.1:8080/rest/api/2/search?jql=assignee=raul.pelaez real 0m7.098s user 0m0.004s sys 0m0.012s time curl -D- -u raul.pelaez:*** -X GET -H “Content-Type: application/json” http://10.2.29.224:8080/rest/api/2/search?jql=assignee=raul.pelaez real 0m7.562s user 0m0.008s sys 0m0.008s time curl -D- -u raul.pelaez:*** -X GET -H “Content-Type: application/json” https://jira.domain.com/rest/api/2/search?jql=assignee=raul.pelaez real…

Read More