![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
Using EPIC issue type can help us in organize all own issues. Out-of-the-box functionalities give us all the necessary BUT….. ….. if we need more information from issue in EPIC, what we can do to show new columns? Let me explain We have a great help using Issue Matrix from Botron. This addon helps us…
Read More
We have talked about the Servlet extraction of worklogs: How to extract an Excel report from Tempo Timesheets using an URL We have talked also about the Tempo API REST worklog extraction using groovy: How to list your Jira Tempo Teams and members in a Confluence page Jira Groovy example script to get Tempo Teams…
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
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 MoreStep 1. Create the plugin project If you have not already set up the Atlassian Plugin SDK, do that now: Set up the Atlassian Plugin SDK and Build a Project. Enter the following command to create a plugin skeleton: atlas-create-jira-plugin Choose 1 for JIRA 5 when asked which version of JIRA you want to create…
Read MoreSyntax: issueFunction in LastCommentContains(” query…”, “text to find”) Isn’t Key Sensitive
Read MoreJQL Syntax sample: project = XXX AND issueFunction in UserInRole(” “, assignee, “Developer”) // note the space in the first parameter, this syntax is less efficient issueFunction in UserInRole(” project = XXX “, assignee, “Developer”) //more efficient issueFunction in UserInRole(” project = XXX “, reporter, “Developer”)
Read MoreHere is a function with two input parameters to show, as result, a list of issues that it’s worklogged hours sum more than the input parameter two. It’s an easy function to know how create new JQL custom methods.
Read MoreOn {JIRA_GOME}/scripts/ create this folders: For example: ../jira_home/scripts/com/onresolve/jira/groovy/jql Then add the groovy file with the new JQLFunction, exmaple: HasInactiveAssignee.groovy The code: Then Go to Addons –> ScriptRunner –> Script JQL Functions –> and then press “Scan” Syntax: issueFunction in hasInactiveAssignee(‘project = XXX’) That’s all!
Read More
Our recommended books:
 |
 |
 |
 |
 |
www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog - [www.MrAddon.blog] ® 