soumyajit_blog

 //Description: used for create subtask per component in  If user select coponents and CIP# field value // Date: 2021-07 import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.issue.Issue import com.atlassian.jira.issue.IssueInputParametersImpl import org.apache.log4j.Logger import com.atlassian.jira.issue.CustomFieldManager def log = Logger.getLogger("com.acme.workflows") def ftopor_cip_customField =  ComponentAccessor.getCustomFieldManager().getCustomFieldObject("customfield_20320"); def ftopor_cip_values = (String)issue.getCustomFieldValue(ftopor_cip_customField); final newLabel = 'create_subtask' if (!issue.subTask) {     //log.warn (issue.getComponentObjects().getAt(0)?.getName())     no_of_componets = issue.getComponentObjects().size()     if(no_of_componets>0){         for (i=0; i<no_of_componets; i++){             createSubtask(issue,issue.getComponentObj...

 import com.onresolve.jira.groovy.user.FormField import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.bc.issue.search.SearchService  import com.atlassian.jira.jql.parser.JqlQueryParser import com.atlassian.jira.web.bean.PagerFilter import com.atlassian.jira.issue.search.SearchQuery def user = ComponentAccessor.jiraAuthenticationContext.loggedInUser def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser) def searchService = ComponentAccessor.getComponent(SearchService) FormField cip_form_val = getFieldByName("CIP#"); def projKey = 'FTOPOR' def cip_submitted_value = cip_form_val.getValue().toString() //f jqlSearch = 'project = ' + projKey + ' AND "CIP#" ~ "\\"' + cip_submitted_value + '\\""' //f query = jqlQueryParser.parseQuery(jqlSearch) //f results = searchService .search(user,query, PagerFilter.getUnlimitedFilter()) //results.getResults() //(results.getTotal()!= 0) if (cip_s...

Some jira application tips, that you needed some time for performance analysis purpose. 1. Found inactive jira project that is last updated on 01/01/2015: SELECT  p.PNAME as "Project Name",p.pkey as "Project Key",count(i.id) as "# of issues", to_char(MAX(i.UPDATED),'dd/mm/yyyy') as "Last Update Date",c.display_name||'('||p.LEAD||')' as owner FROM jiraissue i, project p, cwd_user c where p.ID = i.PROJECT and p.LEAD=c.user_name HAVING MAX(i.UPDATED) < to_date('01/01/2015','dd/mm/yyyy') GROUP BY p.pkey,p.LEAD,p.PNAME,c.display_name ORDER BY MAX(i.UPDATED) ASC;