I've added two ScriptRunner Scripted Fields to my Jira instance...
These fields will look at the defined start/end dates for the Sprint and stuff those into the two custom fields appropriately. Everything works fine... I can pull these fields into columns on the "Search for issues" however when I try and use these two new fields as part of a JQL Search, they're not available.
This is just one of my Scripts to return the Sprint Start Date...
// Required Imports
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import java.text.SimpleDateFormat;
import java.util.Date.*;
import com.atlassian.jira.issue.customfields.searchers.TextSearcher
// Get the current issue key
Issue issue = issue
// Get a pointer to the CustomFieldManager
def customFieldManager = ComponentAccessor.getCustomFieldManager()
// Get a pointer to the sprint CF
def sprintCf = customFieldManager.getCustomFieldObjectByName("Sprint")
// Stop the values on screen showing old cached values
enableCache = {-> false}
// Define a new Java Simple Date Format
SimpleDateFormat sdfDate = new SimpleDateFormat("dd/MMM/YYYY");
// Get the Start Date for the Sprint
Date sprintStartDate = issue.getCustomFieldValue(sprintCf)?.startDate?.first()?.toDate()
// Return the output Date
return sprintStartDate
I re-indexed Jira after the field was implemented.
What am I doing wrong? Why can't I use JQL to Search on these fields?
Thanks in advance!
Hi @Shawna Morris,
If you want to search on the calculated value then you will need to configure an indexer. Take a look at this doc.
Do you have this configured?
I guess the second time is a charm in this case. I was fiddling with the Searcher and had previously tried the "Date Time Range picker" and it didn't work. Now it is. Thank you for having me double-check!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Woohoo!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@mogavenasan I don't understand how you get to that screen where a searcher can be selected - please can you explain?
I don't see that option when creating a new Scripted Field, nor when editing one.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, this is Olly from ScriptRunner Support!
Searchers for each Scripted Field can be found when looking at the Administrator -> ScriptRunner's Field page as per the below:
Furthermore, I've noticed @mogavenasan linked our old Documentation!
We've recently moved everything to a new page here!
Specifically, the page in question for this question is here!
Kind Regards,
Olly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.