I am looking to create a filter for a project that will show the issues created in a certain date range but am having issues creating the syntax. I'm lost on how to create the date range. Any help would be appreciated!
@Jason Bane As an example, if you want to search for issues created between a date range 1 Jan 2018 to 31 Dec 2018, and want to list them in desceding order by creation date, you can use the below JQL query for your filter:
project = "your-project-name" AND created >= "2018-01-01" AND created <= "2018-12-31" order by created DESC
Please let me know if this helps!
I'm using reset API to get the issue details using python requests and it seems like date range is not working.
Suppose I wanted to extract the issue details which has been updated/created between 1st Jan 2018 to 31st Dec 2018. I have tried using below format and it returns all the issue's which has been updated greater than 1st Jan 2018 to till date and not limited to Dec 31 2018.
Can someone help on this to retrieve issue's updated or created between date range
Hi @Jason Bane
You could use something like this:
project=xyz and created > startOfMonth() and created < endOfMonth()
gets the xyz issues created in the current month. Refer to other functions in https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html
You can also give specific dates instead of date functions.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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