Error while fetching requested data via JQL Query

[Deleted user]

I have created a scripted field which can display the RAG status of an issue and when I am trying to apply JQL query to filter RAG Status under "view all issues and filters" option, I am not able to get the RAG status in proper order

Example - project="xyz" AND RAG_Status="Green"

I expect only issues with status as GREEN, will be displayed as the result of query. But now I am able to view "RED" status also as the result.

I cross checked the script but there is no issue in it.

Can you please provide a solution for the above mentioned issue.

[Alexey Matveev · Accepted solution]

Kindly make sure that your scripted field uses a Search template and try to reindex your project.

[Deleted user]

Hi Alexey,

Thanks for the above response, I have already added "Free text Searcher" under Search Template.

[Alexey Matveev]

Did you reindex your project?

[Deleted user]

Yeah, when I re-index filter will be working fine. But next day again I will face the same issue.

[Alexey Matveev]

It should not happen next day again. When you add a custom field or change the search template, it is necessary to make a reindex. Jira even warns you about it.

After reindexing, indexes will be updated upon issue updates. If your scripted field depends on the values of custom fields of the same issue, then everything will be fine. If your scripted field depends on some other data, then you can have a problem. You can read more in the JQL Searches in Script Fields part of this document:

https://scriptrunner.adaptavist.com/5.0.4/jira/scripted-fields.html

[Deleted user]

Thank you very much for the suggestion Alexey. I was actually fetching data from different issue types. So, it would be causing issue and i am re-framing the scripts now. Please let me know if you have any suggestions on fetching data from different issue types.

[Fabio Racobaldo _Catworkx_]

Hi Jeevan,

you need to check the searcher associated to your field. Probably it is not selected.

In order to that, you need to perform the following steps :

1. Go to the custom field list and locate your own scripted field
2. Click edit on the right
3. Select a Search Template (I suggest Free Text Searcher)

It shoud fix your issue.

Ciao,

Fabio

[Deleted user]

Hi Fabio,

Thanks for the above response, I have already added "Free text Searcher" under Search Template.