I am exporting to a .csv file the time the issue was in each Kamban status, but I am not able to get this update from the history table through jobs
@[deleted]
Please provide more details about exactly how you are trying to do this.
import com.atlassian.jira.util.ImportUtils import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.bc.issue.properties.IssuePropertyService import com.atlassian.jira.bc.issue.search.SearchService import com .atlassian.jira.web.bean.PagerFilter import com.atlassian.jira.jql.parser.JqlQueryParser import com.atlassian.jira.issue.search.SearchProvider import com.onresolve.scriptrunner.runner.customisers.PluginModule import com.onresolve .scriptrunner.runner.customisers.WithPlugin def jqlQueryParser = ComponentAccessor.getComponent (JqlQueryParser) def issueManager = ComponentAccessor.getIssueManager () def logUser = "login do usuário de serviço"def user = ComponentAccessor.getUserManager (). getUserByKey (logUser); // def AuthContext = ComponentAccessor.getJiraAuthenticationContext () //AuthContext.setLoggedInUser(logkey) def searchService = ComponentAccessor.getComponent (SearchService.class) // CURRENT date Calendar cday = Calendar.getInstance (); // Primeiro dia do mês anterior Calendar fday = Calendar.getInstance (); // leva a data atual fday.set (Calendar.DAY_OF_MONTH, 1); // obtém o primeiro dia do mês atual fday.add (Calendar.MONTH, -1); // obter o mês anterior // primeiro do mês atual Calendar lastDay = Calendar.getInstance (); lastDay.set (Calendar.DAY_OF_MONTH, 1);// ------------------------------------------------ -------------------------------------------------- ---------------------- / * EXPORT FOR KPR * / // def KPRjql = "project = KPR and created> '" + fday.format (' yyyy -MM-dd ') + "' e criado <'" + lastDay.format (' aaaa-MM-dd ') + "'" // def KPRjql = "project = KPR e criado> '2021/03/29' " def KPRjql =" projeto = KPR e criado> '2021/03/30' " def KPRquery = jqlQueryParser.parseQuery (KPRjql) def KPRresults = searchService.search (usuário, KPRquery, PagerFilter.getUnlimitedFilter ()) // def KPRfilePath = "/export/atlassian/application-data/jira/shared/export/full_export_KPR.csv"// novo arquivo (KPRfilePath) .createNewFile () // PrintWriter KPRwriter = new PrintWriter (KPRfilePath, "UTF-8")//KPRwriter.println("Key;Time;From;To; Time Fim ") KPRresults.getResults (). Each {KPRdocumentIssue -> def KPRissue = issueManager.getIssueObject (KPRdocumentIssue.id) def KPRkey = KPRissue.getKey () / /KPRwriter.println(KPRkey+";"+KPRissue.created.format('dd-MM-yyyy HH: mm: ss ') + ";; Backlog") def KPRchangeHistoryManager = ComponentAccessor.getChangeHistoryManager (); def KPRstatuschange = KPRchangeHistoryManager.getChangeItemsForField (KPRissue, "status"); KPRstatuschange.each {it -> def horarioinicial = it.created.format ('dd-MM-aaaa HH: mm: ss') def horariofim = it.created.format ('dd-MM-aaaa HH: mm: ss' ) - horarioinicial log.info ("KEY" + KPRkey) log.info ("log.info ("horario fim" + it.created.format ('dd-MM-aaaa HH: mm: ss')) log.info ("De" + it.fromString) log.info ("Para" + it .toString) // KPRwriter.println (KPRkey + ";" + it.created.format ('dd-MM-aaaa HH: mm: ss') + ";" + it.fromString + ";" + it.toString) } } //KPRwriter.close ()
Estou usando este código acima no console, o que eu desejo fazer é que no painel Kanban, ele me traga o tempo que ficou em cada status @Trudy P Claspill
It looks like you're new here. Sign in or register to get started.
