nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Script Listener with JQL don´t show updated issue

Joerg Strehl

Hello,

I need some help with an problem regarding to Listener´s and JQL querys.

So I wrote an Listener which sends an custom mail to the teamleader if the issue is set to priority 1.
In the first step I get the search results from some of our saved filters and then I check if the issue is in one of these filters. Based on the filter I send the mail to the right teamleader.

This works fine until I have an issue with an approval inside the workflow, it seems that the listener is faster than the re-index of the issue in the approval transition.
When I test the script in the console it works.

Is there any way to slow down the listener or wait until the re-index is done?

Thanks

Joerg

Accepted answers

All comments

Antoine Berry

Hi @Joerg Strehl ,

What even are you listening to ? I am not sure why you need to run a JQL here. Maybe check the order of post-functions, particularly in the approval transition.

Joerg Strehl

Hi @Antoine Berry ,

i have created an custom event for approved issues.

I run the JQLs because we have about 10 teams which work in the Jira Service Desk, so i look if the issue is in one of the service desk queues (filter) and based on this i send an custom email to the PO and the teamleader.

It works fine if the issue is shown in the filter direct after the creation. But in all of our filters we don´t show the issues which are in the status "Waiting for approval".
When the issue is approved, the event is fired and the listener runs but it looks like that the issue is not found by the filter. When i run the code of the listener in the script console after the approval, it works. It seems that the listener starts before the reindex of the issue is done.

The event is in the transition after the re-index function.

Thank you

Antoine Berry

Hi @Joerg Strehl ,

I am still not sure why you are running a JQL (maybe I understand if wrong). If you run the script in a post-function and if the priority is 1, send the mail about this particular issue. If you want to run JQLs, I would probably do it in a service every hour (for example) and send a mail if an issue with priority 1 is found.

Anyway I was able to replicate your issue and fix by running the code in a thread and adding a reindex :

Thread.start({

def issueIndexingService = ComponentAccessor.getComponent(IssueIndexingService)
issue.store()
issueIndexingService.reIndex(issue)

//Run your code here

})

Hope that helps.

Joerg Strehl

Hi @Antoine Berry

Thank you for your help but I can´t get it work.

Where I have to put this code, into the "Approval" - Postfunction or into the Script Listener?

Antoine Berry

That would be in the script listener, using your current code.

Joerg Strehl

Ok I tried it, but when I add the "Thread.start" code it is not working.

This is my code whitout the "Tread" code:

import groovy.text.GStringTemplateEngine
import com.atlassian.mail.Email
import com.atlassian.mail.server.MailServerManager
import com.atlassian.mail.server.SMTPMailServer
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.bc.user.search.UserSearchService
import com.atlassian.jira.user.UserPropertyManager
import com.atlassian.jira.user.ApplicationUser
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.bc.filter.SearchRequestService
import com.atlassian.jira.issue.search.SearchRequest
import com.atlassian.jira.issue.index.IssueIndexingService
import com.atlassian.jira.util.ImportUtils


Issue issue = event.issue
def issueKey = issue.getKey()


def userManager = ComponentAccessor.getUserManager()
def cfManager = ComponentAccessor.getCustomFieldManager()
def userPropertyManager = ComponentAccessor.getUserPropertyManager()
def constantManager = ComponentAccessor.getConstantsManager()
def currentAppUser = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def issueFactory = ComponentAccessor.getIssueFactory()
def issueManager = ComponentAccessor.getIssueManager()
def customFieldManager = ComponentAccessor.customFieldManager
def baseurl = com.atlassian.jira.component.ComponentAccessor.getApplicationProperties().getString("jira.baseurl")
def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchService = ComponentAccessor.getComponent(SearchService)
def searchRequestService = ComponentAccessor.getComponent(SearchRequestService)
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def groupManager = ComponentAccessor.getGroupManager()
def adminUsers = groupManager.getUsersInGroup("jira-administrators")




def rendererManager = ComponentAccessor.getComponent(com.atlassian.jira.issue.RendererManager.class)
def fieldLayoutItem = ComponentAccessor.getFieldLayoutManager().getFieldLayout(issue).getFieldLayoutItem("description")
def renderer = rendererManager.getRendererForField(fieldLayoutItem)
String desc = renderer.render(issue.description, null)

//--------- Wert aus dem Feld Priority reason holen ---------
def prioReasonVal = issue.getCustomFieldValue(ComponentAccessor.customFieldManager.getCustomFieldObjectsByName("Priority reason").getAt(0)) as String
String prioReason = renderer.render(prioReasonVal, null);


//--------- Prüfung auf IssueType um Ausführung zu steuern ---------
def acceptedIssueTypes = ["Service Request", 
"Service Request with Approvals", 
"Approved Account Request", 
"Services Article Data", 
"Services Customer Master", 
"Serial number ActionCode", 
"SAP Service", 
"SAP changes in forms", 
"SAP mass creation of order ", 
"Reservation mobile POS", 
"Store sales promotion", 
"daex-sftp.onconrad", 
"Service Request Hardware with Approvals", 
"Service Request Permissions with Approvals", 
"Service Request Software with Approvals", 
"SR - Disable User IT ", 
"SR - STEP User/Supplier", 
"SR - Telephone", 
"Data exchange workflow", 
"SR - Approval GF", 
// "Qlik", 
"SR - GCP Project", 
// "RST", 
"EDI Service", 
"Mobile Device Configuration"]
// "CBDP Data Governance"]


if (issue.priority?.name != 'Prio 1 - Critical')
{ return true }

if (issue.getStatus().name == "Waiting for approval")
{ return true }

if (issue.isSubTask())
{ return true }

if (issue.issueType.name.contains("eCom") || issue.issueType.name.equals("Analytic Requests (CI)") || issue.issueType.name.contains("MDM") || issue.issueType.name.equals("OM Marketing Services") || issue.issueType.name.equals("RST") || issue.issueType.name.equals("Contract management") )
{ return true }

if(issue.getIssueType().name in (acceptedIssueTypes))
{



//--------- JQL Abfrage für PO Zuordnung ---------

String jqlQuery = ""
def query = null
def searchResultsInfraOps = null
def searchResultsSysOps = null
def searchResultsXCM = null
def searchResultsCRM = null
def searchResultsBigData = null
def searchResultsPOS = null
def searchResultsSCM = null
def searchResultsEWM = null
def searchResultsOMS = null


adminUsers.each{ adminUsersFilter -> 
searchRequestService.getOwnedFilters(adminUsersFilter).each{SearchRequest filter->

if (filter.name.toString() == "DE Infra-Ops All"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsInfraOps = searchService.search(adminUsersFilter,query, PagerFilter.getUnlimitedFilter()).getResults()
}

else if (filter.name.toString() == "CESD: XCM All"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsXCM = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
}

else if (filter.name.toString() == "CESD: Queue CRM - Open Issues"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsCRM = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
} 
else if (filter.name.toString() == "CESD: Queue BigData/PBis - Open Issues"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsBigData = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
}
else if (filter.name.toString() == "CESD: Queue POS - Open Issues"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsPOS = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
} 
else if (filter.name.toString() == "CESD: SCM All"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsSCM = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
}
else if (filter.name.toString() == "CESD: Queue IT-EWM - Open Issues"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsEWM = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
} 
else if (filter.name.toString() == "CESD: Queue OMS - Open Issues"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsOMS = searchService.search(adminUsersFilter, query, PagerFilter.getUnlimitedFilter()).getResults()
} 

else if (filter.name.toString() == "CESD: SysOps All"){ 
jqlQuery = filter.query?.getQueryString()
query = jqlQueryParser.parseQuery(jqlQuery)
searchResultsSysOps = searchService.search(adminUsersFilter,query, PagerFilter.getUnlimitedFilter()).getResults()
} 
}
}



log.warn("Filter InfraOps ${searchResultsInfraOps}")

//--------- Setzen der eMail-Adressen ---------

def emailAddr = ""
def emailAddrCC = ""
def filter = null

if (searchResultsInfraOps.toString().contains(issueKey)) {
emailAddr = "mail1@test.de"
filter = searchResultsInfraOps
}
else if (searchResultsXCM.toString().contains(issueKey)) {
emailAddr = "mail@test.de"
filter = searchResultsXCM
}
else if (searchResultsSysOps.toString().contains(issueKey)) {
emailAddr = "mail2@test.de"
filter = searchResultsSysOps
}
else if (searchResultsCRM.toString().contains(issueKey)) {
emailAddr = "mail3@test.de"
filter = searchResultsCRM
}
else if (searchResultsBigData.toString().contains(issueKey)) {
emailAddr = ("mail4@test.de")
filter = searchResultsBigData
}
else if (searchResultsPOS.toString().contains(issueKey)) {
emailAddr = "mai5l@test.de"
filter = searchResultsPOS
}
else if (searchResultsSCM.toString().contains(issueKey)) {
emailAddr = "mail6@test.de"
filter = searchResultsSCM
}
else if (searchResultsEWM.toString().contains(issueKey)) {
emailAddr = "mail7@test.de"
filter = searchResultsEWM
}
else if (searchResultsOMS.toString().contains(issueKey)) {
emailAddr = "mail8@test.de"
filter = searchResultsOMS
}


else { emailAddr = "mail@test.de"
//return true 
}

def status = issue.getStatus().name 
//--------- Erstellen der EMail ---------

def subject = "Issue ${issue.key} was created with Prio 1 - Critical"
def body = """<div style="color:#172b4d;font-family:-apple-system,BlinkMacSystemFont,'Segoe UI','Roboto','Oxygen','Ubuntu','Fira Sans','Droid Sans','Helvetica Neue',sans-serif;font-size:14px;font-weight:400;line-height:1.429;letter-spacing:0"> 
<div> 
<br>
<p>
<b>Issue Key:</b><br> 
${issueKey} 
</p>
<p>
<b>WF-Status:</b><br> 
${status} 
</p>
<p>
<b>EMail Empfänger:</b><br> 
${emailAddr} 
</p>
<p>
<b>Filter InfraOps:</b><br>
${searchResultsInfraOps}
</p>
<p>
<b>Filter Ergebnis:</b><br> 
${filter} 
</p>
<p>
<b>Reporter:</b><br> 
${issue.reporter.name} 
</p>
<p>
<b>Issue priority:</b><br> 
${issue.priority.name} 
</p>

<p>
<b>Summary:</b><br> 
${issue.summary}
</p>

<p>
<b>Description:</b>
${desc}
</p>

<br>
<p>
<a href="${baseurl}/servicedesk/customer/portal/1/${issue.getKey()}">View request</a>
</p>

</div>
</div> 
<p style="color:#7a869a;font-size:12px"> 
Conrad Service Desk, powered by <a href="https://www.atlassian.com/software/jira/service-desk/powered-by?utm_medium=email&utm_source=service-desk_email-notification_server&utm_campaign=service-desk_email-notification_server" style="color:#0052cc;text-decoration:none" target="_blank" data-saferedirecturl="https://www.google.com/url?q=https://www.atlassian.com/software/jira/service-desk/powered-by?utm_medium=email&utm_source=service-desk_email-notification_server&utm_campaign=service-desk_email-notification_server&amp;source=gmail&amp;ust=1568799068422000&amp;usg=AFQjCNHsRij9VI1uF-1vLco6cCyleAZqgA">Jira Service Desk</a>
, sent you this message. 
</p>""" 



//--------- Versand der EMail ---------

SMTPMailServer mailServer = ComponentAccessor.getMailServerManager().getDefaultSMTPMailServer();

if (mailServer) 
{
Email email = new Email(emailAddr)
email.addHeader("X-Priority", "1 (Highest)")
email.setMimeType("text/html")
//email.setCc(emailAddrCC)
//email.setBcc(emailAddrBCC)
email.setSubject(subject)
email.setBody(body)
mailServer.send(email)
} 
else 
{
// Problem getting the mail server from JIRA configuration, log this error
}
//}
}