Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Can I create a query that gets results from as at a given date?

I want to create a page in confluence that gives a status report, some of the content of that report will take content directly from jira. 


Is it possible to create a query that is as per a given date based on the issue history.  e.g. If the report is for the project on the 15th of March and on the 16th an issue in the report gets updated the report should still reflect 15th of march? Even if I go back and look at it on the 17th. 

1 answer

1 accepted

0 votes
Answer accepted
yuliia_b__SaaSJet_ Marketplace Partner Jun 17, 2022

Hi @Daniel Park 

What data do you need in your report exactly?

Most of the historical fields aren't supported by JQL, you can find more info here:

History searches with & without JQL [10 examples]

If you're ok with third-party solutions, check out Issue History for Jira app. Here you can filter issues by projects, sprints, assignees, etc. The date choosing option is also available. Add any issue field you want to monitor changes for – and you create the report you need. 

You'll get all changes in chronological order.


The add-on is developed by my team. There is a 30 days free trial, so you can check if it can help with your case.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,995 views 37 49
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you