Search result is not correct

[ClaireYang]

I use JQL "project = A and issuetype = BUG and customfield_xxxx is empty" to do advance search, jira returns 2 results. Actually there should be 4 results.  

Does anyone know the reason?

[Trudy Claspill]

Hello @ClaireYang 

Without seeing the data we cannot tell you why the results don't match your expectations.

For the two items you expect that are missing the possible reasons are:

• They are not in project A
• The issue type is not BUG
• The custom field contains data
• The issues are not visible to you due to permissions.
• The missing issues have not been properly indexed for searching

[ClaireYang]

I'm trying do the re-indexing. I'll try later when it finished.

Thank you 

[Arkadiusz Wroblewski]

Hello @ClaireYang 

if those 2 issues really match the same project, issue type, and permissions, then I would suspect either an indexing problem or the known Jira Server issue with custom field IS EMPTY searches not returning all expected results. Atlassian logged that behavior under JRASERVER-71042.

So I would first verify the field is truly empty on those issues and then check indexing / Jira version.

PS: Some of users stating it helped them Full Reindex.

Have a great start Week.

[Tiina Savolainen]

Has there ever been anything at customfield_xxxx? That could be the reason "it's not empty"

[ClaireYang]

Yes, it's empty. It's a date picker field, and show blank.