Mandatory Field does not show in JQL

[Hemanshu Sood]

Hi all,

I have field marked as mandatory in a Scriptrunner behavior. Lets say the field name is cf123

Before creating this behavior, there are many stories in my project which have no value for cf123 and hence, are empty

Now when I created this behavior, new ticket creation will require a value for cf123, while existing will require a value while editing.

When I created a jql for existing stories however the stories with no value of cf123 do not show up:

jql:

project = XYZ and issuetype = Story and cf123 is EMPTY 

this is expected to show 23 results, but is showing zero results.

Is it related to behavior? How can I fix this?

Thank you in advance

[Samuel Gatica _ServiceRocket_]

Hi @Hemanshu Sood 

Welcome to the community!

Please attempt to execute a background reindex in Jira and then try again.

ref: Understand the index process in Jira server 

Hope this helps!

Best regards

Sam,