The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi Team,
I would like to have a JQL query to filter the jira tickets based on Shift basis per quarter.
Example:
Need to query the 6am to 15PM jira tickets for each quarter
Please help.
Hi @Venkatesh T Gowda This is very interesting requirement. We can filter issues based on date range as below. This example will give you issues created in last quarter from 1st oct to 31st dec.
created >= "2021/10/01" AND created =< "2021/12/31"
However adding time range for the same field 'created' won't help as it will not produce right result and will only consider superset i.e. date range specified.
To filter out issues based on time range, I would suggest to use dropdown custom field say 'Shift' and use it with above query to get required results.
Hope this helps.
Hi @Suvarna Gaikwad , thanks for your update. Sure will try as you suggested.
Basically we need to prepare a report every Month and quarter to get the JIRA tickets created based on the shift we work.
I have tried all the way to get this data but failed.
Is there any way we can come up with this feature?
Thank you,
Venky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try this filter for the previous month:
created >= startOfMonth(-1) AND created < endOfMonth(-1)
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jira Community! I’m Mark, a product manager working on Jira Software. Today, I’m happy to announce that we’re launching custom filters for team-managed projects. If you’ve used the quick filters...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.