How to make massive changes in JIRA JQL filters

Imagine you want to change the name or the classification of the project "categories" in your JIRA projects... or names of customfields.... Then, a lot of JQL queries and filters will fail... ¿How we can change the JQL sentences in mode massive of all filters of JIRA? The only solution is making the change in … Continue reading How to make massive changes in JIRA JQL filters

Advertisements

NewRelic: The best Monitoring tool for JIRA

Good morning my proletarian psychic workers! 🙂 These days I was working analyzing the transactions of my JIRA to get better performance and to solve different problems. Due this, the first thing to do is to find the best tool to analyze all the http/s requests and querys to the database also the external services, … Continue reading NewRelic: The best Monitoring tool for JIRA

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 … Continue reading JIRA trick: Set one more category status color! The “undefined color” (black color)

How to change the creator of a page in Confluence 5.2 or above

For Confluence 5.2 and above To change the creator of a specific page Run this SQL query against your database, replacing these values: <lowerusername> with the username of the new creator in lower case 'the title of the page' with the page title (case sensitive) <thespacekey> with the spacekey in uppercase update content set creator … Continue reading How to change the creator of a page in Confluence 5.2 or above

Database Custom Fields with Kepler Plugin. Show a list of issues of one JIRA project in a Custom Field

1.- Install the plugin: https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.keplercf 2.- Create a Custom Field of the new Type "Database Custom Field" 3.- Go to your apache-tomcat/conf/context.xml and add the Datasource (first you need to install the Database JAR Driver if it's different database Oracle, MySQL,... for example in apache-tomcat/lib/mysql-connector-java-5.1.17.jar 4.- Restart Tomcat 5.- Go as Admin to --> JIRA --> Add-ons … Continue reading Database Custom Fields with Kepler Plugin. Show a list of issues of one JIRA project in a Custom Field