Unable to search unrecognizable DateTime format in Jira Lucene index

103 views Asked by At

I am trying to perform a date range search on a Lucene index generated by Atlassian Jira. I have found serveral guides on how to do range queries (such as this guide), typically resulting in queries similar to:

customfield_10106:[2010-01-10-00-00-00 TO 2020-12-10-00-00-00]

However, the DateTime format in the index seems encoded somehow, and the above query therefore does not work.

Example of dates to be queried

The DateTime values are stored as shown in the following picture from Luke:

enter image description here

Here is a closeup:

enter image description here

Here is what the first result looks like from the IntelliJ debugger:

enter image description here

How to query these dates?

Again, I need to make a range query for these dates, something similar to:

customfield_10106:[2010-01-10-00-00-00 TO 2020-12-10-00-00-00]

How can I perform such a query given the format of the dates in the Lucene index?

For the reference, I am working with an index created by JIRA 7.2.2, with Lucene 3.3.0, programming in Java 8.

0

There are 0 answers