Searching LastViewed Not Bringing Back Results

Question

Hello. I'm trying to use JQL to find tickets viewed on specific dates, or ideally within a date range. I understand it seems to be limited to 50 results but I'm actually not getting any results at all. Does JIRA not store this data for more than a certain number of days?

Query used for example: lastViewed = '2020-01-15'

This doesn't bring back any results, and neither does less than '2020-01-15'. If I do a greater than, it brings back the 50 most recent. I need to be able to find tickets that were viewed for a given date range in the past. Any help is appreciated! Thank you for your time!

John Funk · Answer

Here's the example they use * Find issues last viewed in January 2011: lastViewed > "2011/01/01" and created < "2011/02/01" * Find issues last viewed on 15 January 2011: lastViewed > "2011/01/15" and created < "2011/01/16" Not sure why they use created but it seems to work. Change out the year and see what it does for you.

David Bounds · Answer

@John Funk With lastViewed >= endOfWeek(-4) and lastViewed <= endOfWeek(-1)
I do get results back and this sort of illustrates my issue. I can't search for LastViewed beyond the past week even though obviously I've viewed tickets all year. Is there a limit? For example the above query only brings back results with lastViewed on 1/31/2020.

I'm trying to assist some team members with tracking hours and they sometimes need to review a specific days 'viewed' tickets to jog their memory. So far I can't find a query that actually brings back 'LastViewed' in further than the past week.

John Funk · Answer

work with the numbers (bigger/smaller) to see if anything pops up.