How can I query or get all JIRA project number created in 2020?

[Deleted user]

How can I query or get JIRA project number created in 2020, closed in 202 and currently open in 2020?

Thanks again

[Carla Ann Rowland]

to get every issue type in project, filter with: project in ("insert project name") and ((created date >= "2020/01/01" and created date <= "2020/12/31")) AND status in (open, closed)

----

or: project in ("insert project name") and ((created date >= "2020/01/01" and created date <= "2020/12/31")) AND statuscategory in ("to do", done)

[Bill Sheboy]

Hi @[deleted] 

Would you please provide more details of what you are asking?  That will help the community understand your question and provide some ideas.

• By "project" do you mean a JIRA project?
• How are you closing projects?  Changing permissions to hide them? 
• How are you re-opening projects?

Thanks, and best regards,

Bill

[Deleted user]

• By "project" do you mean a JIRA project?
  • I mean JIRA projects
• How are you closing projects?  Changing permissions to hide them? 
  • Yes we close projects
• How are you re-opening projects?
  • We create new projects.

[Bill Sheboy]

Thanks, @[deleted] 

I do not believe there is a "close" for projects with JIRA cloud, so I am unclear what you mean.

As you are creating new projects when you "re-open" them, you would need some way to compare projects (old and new).  Where are you storing the project number that you mention?