Numbers not adding up

Question

Hi

I did three searches

a) custom field A is null = X issues

b) custom field A is not null = Y issues

c) Pressed search with nothing in the search window. and got Z issues.

Now ideally, i would expect

X + Y = Z

but i found that Z was 50 issues more than X + Y.

How is that possible?

Any ideas guys?

Rahul

Nic Brough -Adaptavist- · Answer

Ok, for a global field, you can rule out projects/issuetypes which do not have the field.

I suspect you might have a broken index for 50 issues, is it possible to schedule a full re-index?  (Not background)

Peter Dittman · Answer

check to make sure the custom field is defined for all issue types - there may be types that don't contain the issue (and therefore aren't considered as part of your "is empty" queries)

Rahul Aich [Nagra] · Answer

Hi Nic

Its global context, text field Custom field.

is empty returns the same results as is null

is null == is empty == 89000 issues

is not null == is not empty == 0 issues

empty search returns = 89050 issues

I cant find out those 50 issues since we are 89K issues, manully identifying is impossible.

My requirement behind asking this question is to identify whether a custom field is safe for me to delete or not. If i am sure that no issues are using this custom field i will delete this.

How can i be absolutely certain that a custom field has not been used?