Using "updated startOfDay()" for JQL query

Question

Hi folks,

I am trying to do a query that would show the latest comment for a story (w/o having to go into each individual story.)

Alex very kindly suggested I use this

updated > startOfDay()

for my query and just wondering:

Do I need to put anything in the () qualifier?

Nic Brough -Adaptavist- · Answer

The updated date covers almost every change you can make to an issue - any field edit, a transition, comment, etc.  It's only really external info that isn't really on the current issue that is ignored (changes in linked pull requests, someone adds a link from another issue to the current one, etc)

danielmaycock · Answer

Hi Nic,

Thanks a lot.  Wondering (if you know) if it just picks up ANY activity, i.e. change of assignee?  Specifically, I'm trying to find out what the last comment was (avoids me having to go into each individual story to see status.)

Thanks!

Nic Brough -Adaptavist- · Answer

No, you don't need anything in there.

But it can be useful.  I don't actually know if it can do absolute dates, but it will accept relative ones - things like +3 or -5, for "three days in the future" and "five days ago".

If you leave it blank, it simply assumes "now"!