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

This widget could not be displayed.

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 ...

This widget could not be displayed.

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

72 views 1 0
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