jql function to return number of days and time.

Question

Hi,

I created a scripted field (datelastfilled) to return a time stamp on a custom field. Now I need to create a query with system date and time - datelastfilled.

Like whats the jql query for currentDateTime? and how do I do minus operation so i can get this down below.

Ex : datelastfilled returns this 2017-05-19 13:05:25.0.

i need jql like   datelastfilled - currentDateTime = total days and hh:mm:ss.

Alexey Matveev · Answer

If it is not a date picker then you have to write your own JQL function, unfortunately

Marija Ušakova · Answer

But my scripted field is not a date picker here, but i had to choose multi text field option because it was giving me $datePickerFormatter.format($value) when its selected as date picker, but when its selected as multiline text its exactly returning the timestamp.

Alexey Matveev · Answer

You would need to rewrite your query. For example, suppose you want a query like this

currentDateTime - datelastfilled = 5m

Your query could be rewritten like this

datelastfilled > now() - 5m and datelastfilled < now() - 4m

You can not find difference up to seconds. only up to minutes, hours, days, weeks.