Can't search on new calculated date field

I have a custom field that was added to approximately 450 issues (after their initial creation). It is a calculated field from the date value in a date field and a number value in a number field.  The number field indicates a number of moths and it gets added to the date field to generate a new date.  When I open and look at each of the 450 issues individually, I see the new field and it has the correct calculated date value.  If I perform an advanced search using the new date field, the only issues that the search finds are ones that were created after the new custom field was added to the issue.  In other words, the new calculated date field was created the same time as the rest of the fields and the issue itself.  The search won't find any issues that had the custom field added to it after the original creation.

Any information on what is happening here and how to make the search work will be greatly appreciated.

Thanks,

Larry

2 answers

I believe that kind of behaviour is kinda' normal. You should understand that calculated CFs will always reflect the last indexing of the issue. If the issue is not modified, even if the CF value is changed, it is not reflected in the index.

What's abnormal is the behaviour you describe here "new calculated date field was created the same time as the rest of the fields and the issue itself". IMHO, that is an observational problem. Alter an issue and see if the behaviour is still the same.

 

Thanks for the reply Radu. I modified the date field of an old issue that is not being found in the search. The new calculated date field was updated but trying the search again does not find that old issue. Any more thoughts?

What kind of CF is it? I mean, developed in-house, bought, .... ?

I'm assuming CF stands for Custom Field and I created it myself.

well, in that case, you need to debug the searcher. I suppose you defined a DateRangeSearcher, right ? <customfield-searcher key="datesearcher" name="Date Searcher" class="com.foo.MyDateRangeSearcher"> ... etc ...

In my case that was a re-index problem: all the issues got included in the search results after re-index or a bulk change.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,317 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot