export file history table

[Deleted user]

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

[Trudy Claspill]

@[deleted] 

Please provide more details about exactly how you are trying to do this.

[Deleted user]

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 Claspill