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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.