![www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog – [www.MrAddon.blog] ®](https://jirasupport.files.wordpress.com/2022/09/cropped-logo-mr-addon-vertical-1.png){kind=logo}
jira confluence admin administration support script scriptrunner groovy mraddon barcelona plugin custom development it technology barcelonatech ethereum development
In this exercise we want to set the GOAL for Summer tickets in Jira Service Desk. To do this, we need two calendars configured in Jira Service Desk (the usual calendar and the summer time calendar). Now we can fork the GOALS of each SLA and do the trick! The trick is use the JQL…
Read More
You can download the cheat sheet here: atlassian-jql-cheat-sheet-2 If you need more info about how to use JQL, tricks, etc, we strongly recommend the Book “JQL Per tutti” of Fabio Genovese (Artigiano del Software) Available in Italian, Spanish, Catalan, French and English! Post by MrAddon
Read More
If your company has installed Adaptavist Scriptrunner you are in luck! You are available to do a search for labels using a wildcard expression using JQL You can use the JQL function issueFieldMatch Example of usage: issueFunction in issueFieldMatch(“project = JRA”, “labels”, “ie[8|9]”) This will search for tickets with “ie8” and “ie9” labels issueFunction in…
Read More
Following my job experience, I report some tips, I’ve selected for this post, about JQL. Manage SQL using JQL We can use SQL inside JQL using SQL for Jira Driver – Convert JQL to SQL, a powerfull addon for Jira Server version which translate SQL using new JQL Methods :), as shown in following image……
Read More
Amazing post of bluemonkey, see here
Read More
Sometimes we need to transition issues from one status to other, but these issues can be from different projects and can be from different Workflows. In this case, probably the Transition IDs will be different. For this reason we need to develop a “discover transition” function. See below an example of how we can start…
Read More
Good news people! The plugin “Enlarge Your Excel Export” is back for the new JIRA Server 7.4 version! The new JIRA 7.4 has available again the HTML export! (The old Excel Export), and as always, the export is limited. With this plugin, you will export all the result issues of your JQL query! Very easy…
Read More
There are two tricks to improve the performance and the security of a large Jira Server 7.4 For the first “trick“, we can develop a little Jira plugin, or we can set a “Script Fragment” with the plugin Adaptavist Groovy Scriptrunner. The purpose of the improvement is to avoid problematic JQL queries. In Jira, by default,…
Read More
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…
Read More
New custom JQL function for JIRA 7.x to filter the TOP ROWS of a Query! Very useful! By default filters the TOP 10 rows. The JQL function is writed in Groovy and deployed with Adaptavist Scriptrunner. Syntax example: (to extract the top 20 rows of a project called JIRA) issuefunction in TopRows( “project = JIRA ORDER…
Read More
Do you remember the old post LasCommentContains: New JQL custom function in groovy? With JIRA 7.2 and the new Adaptavist Scriptrunner, the JQL function must be rewrited to work properly. Because after the JIRA migration from JIRA 6.3 to JIRA 7.2 changes a lot of very common classes, etc. You can see the usual changes in…
Read MoreVery 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
Our recommended books:
 |
 |
 |
 |
 |
www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog - [www.MrAddon.blog] ® 