How to create a JQL to show all work from from past to current

[Alicia Morgan]

Hello there - I would like to create a JQL to gather all past work for my project within the last year to current date.  By current date, I mean indefinitely. 

Can someone help me with how to write this query? 

[Mathew Lederman · Accepted solution]

If you want the query to be a sliding scale (shows only tickets created 1 year prior to the current date) you would use something like this:

project = [XXX] and created >= -365d

If you want to go the beginning of the previous year, as @Akbar Gulaliyev said you would use something like this:

project = [XXX] and created >= startOfYear(-1y)

If you want to go to the beginning of the current year, it would be this:

project = [XXX] and created >= startOfYear()

[Akbar Gulaliyev · Accepted solution]

Hello @Alicia Morgan !

What do you mean as all past work? If you mean all tasks you were assigned to, you can try this JQL:

assignee = currentuser() AND (created >= startOfYear(-1y) OR updated >= startOfYear(-1y))

[Craig Nodwell · Accepted solution]

Hi @Alicia Morgan this should be fairly simple.
project = XXXXX AND created <= now()