Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

Community
Products
Jira
Questions
How can i filter for tickets worked on in a date range?

How can i filter for tickets worked on in a date range?

I would like to set up a filter that shows the all the tickets worked on during a range of dates. For example, I would like to see all the tickets with time logged from 2/3/2020 until 2/24/2020

2 answers

1 accepted

0 votes

Answer accepted

Like this:

worklogDate >= "2020-03-02" AND worklogDate <= "2020-02-24"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

When running that filter in my project it is returning 0 results. My filter looks like

project = XXXX AND worklogDate >= "2020-03-02" AND worklogDate <= "2020-02-24" order by created DESC

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Sorry my typo, the format is "YYYY-MM-DD", so it should be:

worklogDate >= "2020-02-03" AND worklogDate <= "2020-02-24"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Thanks a ton

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

0 votes

Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

If it worked can you mark the answer as accepted please?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase