Use JQL to locate issues in a script

This is an example script for when Profile’s Script Field Processor or Project Mapping: Script Rule is required to detect whether an issue can be located via JQL Query.

Example

The following ECMAScript (JavaScript) code will run a JQL query to find an issue. The key of the first issue found in the results is set as a value for "issueKey" in the resultMap object. This "issueKey" directive would then ultimately direct JEMH to comment on the existing issue with the processed email. Note that this behaviour is just an example - you could do anything with the returned issue(s).

The below example would match against an issue that has all the following values:

Field A

Field B

Field C

Field A

Field B

Field C

apple

blueberry

carrot

 

Since JEMH 3.3.21 we lock down access to arbitrary classes in the script context, they cannot be accessed using historic methods:

1 2 var filter = PagerFilter.static.getUnlimitedFilter(); var builder = JqlQueryBuilder.static.newBuilder();

but need to be gained through fully specified class names:

1 2 var filter = Java.type("com.atlassian.jira.web.bean.PagerFilter").getUnlimitedFilter(); var builder = Java.type("com.atlassian.jira.jql.builder.JqlQueryBuilder").newBuilder();

These specific classes were not initially added, are available since JEMH 3.3.38

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 //get the user to run the JQL query as var user = userManager.getUserByName("admin"); var filter = Java.type("com.atlassian.jira.web.bean.PagerFilter").getUnlimitedFilter(); var builder = Java.type("com.atlassian.jira.jql.builder.JqlQueryBuilder").newBuilder(); //construct the JQL query var query = builder.where().defaultAnd() .field("Field A").like("apple") .field("Field B").like("blueberry") .field("Field C").like("carrot") .buildQuery(); //get list of issues (could be empty) var results = searchService.search(user, query, filter).getIssues(); //get first issue if exists and add via issueKey directive if (results.size()>0) { var issue = results[0]; resultMap.put("issueKey",issue.getKey()); print("Found using JQL: "+issue.getKey()); } else { print("No issues match using JQL."); }