Hello,
I need to understand the difference between the below three JQLs-
created >= -30d
createdDate >= -30d
createdDate >= startOfDay(-30d)
Regards
Priyanka
Hi @Priyanka khare ,
The first 2 are exactly the same. Both created and createdDate are ways to refer to the system date/time logged automatically when a ticket was created. -30d simply means count back 30 days from that moment.
StartOfDay(-30d) counts back 30 days from 0.00 AM on the current day. Essentially you count back 30 days from the date switch on the calendar.
Hi @Priyanka khare
There is no difference between created and createdDate. It is just like an alias, both can be used. Also it is not the only one. Type/issuetype, key/issuekey, due/duedate are some other examples.
All queries should return same result.
@Walter Buggenhout
Thankyou for the answer.
If i need to access the number of stories created within the last 30 days then my JQL should be-
type= story and createdDate >= -30D
OR
type = story and createdDate >= startOfDay(-30D)
@Tansu Akdeniz
issuetype = Story and createdDate >= -30d
It looks like you're new here. Sign in or register to get started.
