Identifying Active Projects

[Emerico Vespucci]

Hello. We are looking to identify all 'active' projects in our Jira Server instance, v8.20.17.  We are defining 'active' as a project, which has had content created in the last 'X' amount of days.

Our team was considering the use of REST API or JQL or a combination of both. 

I saw the possible use of a database query as well:

Example below. 

select 
pname,pkey,created as project_createtd,updated as project_updatetd
from 
project
where updated <= '2019-10-01T02:15:00.102738Z'

Thank you

[Rushad Shaikh]

Using create sprint option on the backlog screen. 

[Tyler Brown]

Did you clear the Sprint values from the items moved from Project A to Project B?

Can you run a query on one of the Sprints you're having issues with to ensure that there are only issues from one project included?

[Rushad Shaikh]

Yep. Just did and all the items in search are project specific.

[Tyler Brown]

Hey Rushad,

The issue is that Sprints can be shared across projects.

The easiest way to fix this would be to create a board for your two projects and create individual Sprints on these 2 boards.

Documentation on how to create a board can be found here:

https://confluence.atlassian.com/jirasoftwarecloud/creating-a-board-764477949.html

Hops this helps,

Tyler

[Rushad Shaikh]

Thanks Tyler. I do have separate boards for Project A and Project B. Issue is still present.

[Tyler Brown]

Are your boards configured to only show issues from their specific project?

[Rushad Shaikh]

yes

[Tyler Brown]

How do you create your Sprints?