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.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
issuetype = Story and createdDate >= -30d
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.