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

Question

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?

Craig Nodwell_7eve9b · Accepted Answer

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

Akbar Gulaliyev_jlfvn3 · Accepted Answer

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))

Mathew Lederman · Accepted Answer

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()