Jira Custom Field - Missing Issues in Filter result

[Dominik Hicks]

Hi all,

i've created a new custom field in jira. It's a dropdown with 3 possibilities to choose.
One of the three possibilities is set as default value.

When creating a new issue or editing an existing the right default option is preselected.

The problem is that the default option is not automatically set for all the already existing issues. And if I try to filter out the issues for which there is no value in the field yet, only a small part of it is displayed. My filter is set to show all issues where none of the three possible options are in the field.
(Custom_Field" != OptionOne AND "Custom_Field" != OptionTwo AND "Custom_Field" != OptionThree)
The same problem when searching with ("Custom_Field" is EMPTY). Only a few hundred of thousands of issues are shown.

[Eric Lemay · Accepted solution]

Hi Dominik, 

Did you reindex your Jira instance after creating the field?  Until you're able to do that any issue that hasn't been edited since the creation of the field won't turn up in field=empty searches.  

Eric

[Nic Brough -Adaptavist-]

The default is only used on "create issue".  Jira does not presume that it should be set for all empty issues to take the value (in most cases, users don't want it to!)

You will need to use bulk edit to retrospectively amend your data.  Search for "custom-field is empty" to find the ones where it's not set.

[Dominik Hicks]

Yeah, that's exactly the problem. I know how to edit the issues with bulk edit but the filter with "custom-field is empty" doesn't show all issues where the field is not set, only a few of them.

[Moses Thomas]

@Dominik HicksIf all issues  are not displayed that means you  don't have permission to view issues, please  check  project browse permission in all  projects,  and issues security for all  projects.  You  are Jira/system ad-min does not give you  all  rights to  view issues in distinct projects  you  have to  have browse project permission/given rights  in issue security scheme.

Best !

[Dominik Hicks]

The problem is that i can see only a few issues and very many are missing. I'm logged in as the jira admin. I don't think that it is a problem with the permission because I can find, edit and open all missing issues in the issue search without a filter.