Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 21:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Can I use startOfDay() with commented() JQL query

JGB Atlassian Cloud Admin May 27, 2015

I'm using the commented() JQL function (link) to find issues that not have been commented for 1 day.

My current query looks like this:  status = "In Progress" AND issuefunction not in commented("after -1d")

But really, I want to use the "startOfDay()" function instead of "-1d" because if an issue is commented at 5pm on Tuesday, I want it to appear in the query results at 9am on Wednesday. Using the -1d means it won't show up until after 5pm on Tuesday.

I could change the query to -8h or -10h but startOfDay seems better. I can't figure out how to do it.

2 answers

0 votes
Jozef Kotlár
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.
May 27, 2015

AFAIK, this is not possible - commented() is using JqlDateSupport and there is not precision rounding for single date.

0 votes
JGB Atlassian Cloud Admin May 27, 2015

Hmm, maybe the answer is to use -0d to get the beginning of the day?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Upcoming Apps & Integrations Events