JQL Uncategorized

JIRA JQL trick: Filter issues based on transition state execution date in JIRA

Very easy, see the JQL example: Project = “JIRA” AND Status CHANGED TO “In Progress” DURING (“2015/08/01″,”2015/10/05”) Other Syntax: This JQL shows all issues which have been in “Status A” for more than 14 days project=XXX and status changed to “Status A” before startofday(-14) and status = “Status A” This JQL shows all issues which…

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