JQL returning active projects for the past 24months (2 years)

Question

For my Jira Software Projects:

1-I would like a JQL that return all the active projects for the last 24months (2 years)

2-I would like a JQL that return all the inactive project for the last 24months (2years)

Thanks

Mikael Sandberg · Answer

Short answer is no, JQL does not have a function that will do that.

romuald tchokothe · Answer

Thank you.  How can I create a JQL returning last project updated.?

Thanks

Mikael Sandberg · Answer

Hi @romuald tchokothe

Welcome to Atlassian Community!

JQL doesn't have a function that would do this for you, it is intended to search for issues, not projects. You can find project information, like the last time it was used if you go to Settings > Projects. You can also get this information via REST API and the Get projects paginated endpoint.