Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Please let me know how to write a JQL function to see all projects which are active for 2023.

Murli S December 14, 2023

Please let me know how to write a JQL function to see all projects which are active for 2023. I have 100 + Projects. 


After I get the results let me know what JIRA Gadget I can use them in the dashboard to 

2 answers

1 vote
Jack Brickey
Community Champion
December 14, 2023

Hi @Murli S , welcome to the Community.

JQL cannot query projects. It is used to query issues in projects. Can you explain what you mean by an active project? One thing you could do with JQL is to find all issues that have been created since the beginning of the year. So if active is defined by any project where an issue has been created in 2023. Then you could leverage the aforementioned method to help identify those projects. 

Jack Brickey
Community Champion
December 14, 2023

Projects don't have an inherit status like "n progress" or "closed". You can archive projects which could be indicative of closed if you like. In any event JQL does not query projects. Do you currently have some means of identifying statuses for projects? Maybe you could consider using epics to represent a project? In that scenario since epics are issues you could use JQL to find all epics where the status != done.

Murli S December 14, 2023

Hi Jack

As you mentioned JQL Queries are only used for Issues in JIRA I am okay with that response. 

I want to know how can retrieve how many project were created in JIRA for the year 2023 

Jack Brickey
Community Champion
December 14, 2023

There is not a means of doing this natively. You might check the APIs to see if there is a means of pulling that data.

0 votes
Murli S December 14, 2023

Hi Jack 

Thanks for your reply

I need to create a query in JIRA to find all projects which are active like in progress (which means that are not completed or closed) and then I need to create a JIRA gadget to be displayed in the dashboard to be presented to senior management

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events