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 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

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

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

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