Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to require certain fields based on a JQL condition Edited

My requirement is this: Need to require 3 fields to be populated for major incidents. Major incidents are determined by the following JQL:

project = ITIM AND priority in ("0 - (P1) Emergency", "1 - (P2) Critical") OR "P2 Alert" = Yes

"P2 Alert" is a custom field.

So when users resolve the major incident, we want to make sure that three fields are filled out: Start Time, End Time, and Root Cause Owner which are also 3 custom fields.

We do have Adaptavist ScriptRunner for JIRA installed. Thanks in advance.

1 answer

1 accepted

1 vote
Answer accepted
Ivan Tovbin Community Leader Dec 29, 2017

Hi Suzanne,

A scripted validator seems to be the solution here.  But before you begin make sure that:

1) You have a screen attached to your "Resolve issue" transition.

2) That screen has your Start Time, End Time, and Root Cause Owner fields in it.

Next, create a scripted validator using the below code and add it to your "Resolve issue" transition. I'm going to assume that you know how to look up your custom field IDs because you'll need them for the code:

import com.atlassian.jira.component.ComponentAccessor
import com.opensymphony.workflow.InvalidInputException

def cfMgr = ComponentAccessor.getCustomFieldManager()

def projectKey = issue.getProjectObject().getKey()
def priority = issue.getPriority().getName()
def p2Alert = issue.getCustomFieldValue(cfMgr.getCustomFieldObject(11111 as Long)) as String //field id in parenthesis

def startTime = cfMgr.getCustomFieldObject(22222 as Long)
def endTime = cfMgr.getCustomFieldObject(33333 as Long)
def rootCauseOwner = cfMgr.getCustomFieldObject(44444 as Long)

def reqFieldsList = new ArrayList()
reqFieldsList.addAll(startTime, endTime, rootCauseOwner)

if ((projectKey == "ITIM" && (priority == "0 - (P1) Emergency" || priority == "1 - (P2) Critical")) || p2Alert == "Yes"){
for (int i = 0; i < reqFieldsList.size(); i++){
if (issue.getCustomFieldValue(reqFieldsList[i]) == null){
throw new InvalidInputException("'Start Time', 'End Time' and 'Root Cause Owner' are required!")
}
}
}

Hi Ivan, thank you! I do know how to look up the custom field IDs. I'll give it a shot and let you know how it works. Thanks!

Ivan Tovbin Community Leader Dec 29, 2017

I suppose a more flexible solution would be to run a JQL search inside your script and then check the current issue against the results.

Please note that if you want to use quotes ("") inside a String definition, make sure that you place a backslash (\) before them, like so:

String sampleString = "project = ITIM AND priority in (\"0 - (P1) Emergency\", \"1 - (P2) Critical\") OR \"P2 Alert\" = Yes"

import com.atlassian.jira.component.ComponentAccessor
import com.opensymphony.workflow.InvalidInputException
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def currentUser = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

def jqlQuery = jqlQueryParser.parseQuery("project = ITIM AND priority in (\"0 - (P1) Emergency\", \"1 - (P2) Critical\") OR \"P2 Alert\" = Yes")
def resultIssues = searchProvider.search(jqlQuery, currentUser, PagerFilter.getUnlimitedFilter()).getIssues()

for (int i; i < resultIssues.size(); i++){
if (issue.getKey() == resultIssues[i].getKey()){
def cfMgr = ComponentAccessor.getCustomFieldManager()
def startTime = cfMgr.getCustomFieldObject(22222 as Long)
def endTime = cfMgr.getCustomFieldObject(33333 as Long)
def rootCauseOwner = cfMgr.getCustomFieldObject(44444 as Long)
def reqFieldsList = new ArrayList()
reqFieldsList.addAll(startTime, endTime, rootCauseOwner)

for(int v; v < reqFieldsList.size(); v++){
if (issue.getCustomFieldValue(reqFieldsList[v]) == null){
throw new InvalidInputException("'Start Time', 'End Time' and 'Root Cause Owner' are required!")
}
}
}
}

Hi Ivan, I was finally able to try this today and I got the following error. Any ideas?

Script33.groovy:24 [Static type checking] - Cannot find matching method com.atlassian.jira.issue.Issue#getCustomFieldValue(E). Please check if the declared type is right and if the method exists. @ line 24, column 11.

This is odd, it should work as is. But ok, let's change something.

Try this:

import com.atlassian.jira.component.ComponentAccessor
import com.opensymphony.workflow.InvalidInputException
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.fields.CustomField

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def currentUser = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

def jqlQuery = jqlQueryParser.parseQuery("project = ITIM AND priority in (\"0 - (P1) Emergency\", \"1 - (P2) Critical\") OR \"P2 Alert\" = Yes")
def resultIssues = searchProvider.search(jqlQuery, currentUser, PagerFilter.getUnlimitedFilter()).getIssues()

for (int i = 0; i < resultIssues.size(); i++){
if (issue.getKey() == resultIssues[i].getKey()){
def cfMgr = ComponentAccessor.getCustomFieldManager()
def startTime = cfMgr.getCustomFieldObject(22222 as Long)
def endTime = cfMgr.getCustomFieldObject(33333 as Long)
def rootCauseOwner = cfMgr.getCustomFieldObject(44444 as Long)
def reqFieldsList = new ArrayList()
reqFieldsList.addAll(startTime, endTime, rootCauseOwner)

for(int v = 0; v < reqFieldsList.size(); v++){
if (issue.getCustomFieldValue(reqFieldsList[v] as CustomField) == null){
throw new InvalidInputException("'Start Time', 'End Time' and 'Root Cause Owner' are required!")
}
}
}
}

Incidentally, what version of Jira are you using? 

Thanks, we'll give it a shot! We're using 7.3.8.

That worked! Thanks so much Ivan. Perfect. :)

Ivan Tovbin Community Leader Jan 05, 2018

Hi Suzanne,

Glad I could help.

A piece of advice if I may. For performance sake you might want to add a resolution check to your JQL to make the list of returned issues as short as possible so that the script doesn't go through a ton of issues while checking the current issue against them.

Ah, that makes perfect sense. Okay, I'll figure out how to do that on Monday. We are still just testing this in our testing instance. Thanks again!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Asked in Jira Service Desk

Calling all Insight users, we need your help!

Hello Insight users,  As part of our (Mindville's) acquisition by Atlassian, our training team is looking to build some new Insight training materials. It would really helpful if you can ...

162 views 1 1
View question

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you