Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Using "updated > startOfDay()" for JQL query

danielmaycock September 24, 2021

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?

3 answers

1 vote
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2021

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"!

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 27, 2021

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)

0 votes
danielmaycock September 27, 2021

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!

Suggest an answer

Log in or Sign up to answer