I've added two ScriptRunner Scripted Fields to my Jira instance... Sprint Start DateSprint End DateThese 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 Importsimport com.atlassian.jira.component.ComponentAccessorimport com.atlassian.jira.issue.Issueimport java.text.SimpleDateFormat;import java.util.Date.*;import com.atlassian.jira.issue.customfields.searchers.TextSearcher// Get the current issue keyIssue issue = issue// Get a pointer to the CustomFieldManagerdef customFieldManager = ComponentAccessor.getCustomFieldManager()// Get a pointer to the sprint CFdef sprintCf = customFieldManager.getCustomFieldObjectByName("Sprint")// Stop the values on screen showing old cached valuesenableCache = {-> false}// Define a new Java Simple Date FormatSimpleDateFormat sdfDate = new SimpleDateFormat("dd/MMM/YYYY");// Get the Start Date for the SprintDate sprintStartDate = issue.getCustomFieldValue(sprintCf)?.startDate?.first()?.toDate()// Return the output Datereturn sprintStartDateI 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!

rss feed for confluence questions

Is it possible to get RSS feeds for unanswered/all/new questions?

1 answer

1 accepted

Suggest an answer

2 votes

Answer accepted

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?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

Comment

Like • mogavenasan likes this

Woohoo!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@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.

Comment

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:

Screenshot 2022-06-29 at 13.51.14.png

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.

Comment

Like • oguzhankr likes this

Was this helpful?

Thanks!

App Central

DEPLOYMENT TYPE

SERVER

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

rss feed for confluence questions

1 answer

1 accepted

Suggest an answer

Was this helpful?

Thanks!

DEPLOYMENT TYPE

TAGS

Atlassian Community Events