Hi,
My requirement is I like to find number of open jira's per week basis.
for example I want number of Open JIRA's between two dates 2020/12/1 and 2020/12/5 if I am using a filter like " AND status was in (Open) during ("2020/12/1", "2020/12/5")" the problem is it is showing the jira's which are moved to closed/confirmed in between these date. I don't want these jira's to show up.
Can any one help me.
Hi @VARUN KUMAR REDDY ,
Query issues created in a period of time:
created >= 2020-12-1 and created <= 2020-12-31
If you use was, the query result will return all Issues that were in the open state, even if they are closed.
Hi @Ollie Guan
Thanks for the response.
I am not looking for the jira;s that are created in between dates.
My requirement is to get the number of Open JIRAs' (can be created at any date for a given project) between two dates.
For example between 2020/12/01 to 2020/12/05 I want the number of open jira's these open jira's need to be created in between these dates.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
createdDate >=2020-12-01 and createdDate <=2020-012-05 and status was Open
This will gives you info of how many Jira tickets status was changed from open status to Next Status and created between 2020/12/01 to 2020/12/05.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.