The CREATED param in filter gives wrong result

[Nguyen Tuan Trung]

I was trying to filter all new tasks created last week

project = SRP AND issuetype in (Bug, "Change Request", Task) AND created >= 2019-08-19 AND created <= 2019-08-26 ORDER BY priority DESC, updated DESC

return a task with created = 2019-08-25

while

project = SRP AND issuetype in (Bug, "Change Request", Task) AND created >= 2019-08-19 AND created <= 2019-08-25 ORDER BY priority DESC, updated DESC

does not.

[DPKJ · Accepted solution]

This is because, “created” field is timestamp and it takes both date and time (yyyy-MM-dd HH:mm).

Now when you query for issues created <= 2019-08-25, it means 2019-08-25 00:00 (which is zero o’clock on 25th), but your issues were created after that so they are not part of result set.

There was an issue logged against this behaviour to Atlassian but they decided it to not fix to keep backward compatibility.

[Milan Chheda [INFOSYSTA]]

You can the use the below to get issues created last week:

project = SRP AND issuetype in (Bug, "Change Request", Task) AND created > startOfWeek(-1w) and created< startOfWeek() ORDER BY priority DESC, updated DESC