Changing Custom Fields Types in JIRA

Certain fields can be safely upgraded, such as Version and Select lists to their multiple values counterpart. You can change the “customfieldtypekey” in the “customfield” table to whatever you need it to be. The table below lists the keys for commonly changed fields. Custom Field Type Type Key Single Version com.atlassian.jira.plugin.system.customfieldtypes:version Multi Version com.atlassian.jira.plugin.system.customfieldtypes:multiversion Single…

Read More

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