I want to have a look for projects that aren't used quite often. Is there a SQL that can search for projects where last update on an issue was more then 6 months ago. (not with specific time range)
Hi Maarten,
You can use the below SQL to find out the projects which were inactive i.e not used for past months
select * from project where key not in (select distinct(pkey) from jiraissue where updated > "insert your date here")
Yes I found that one... but there isn't one that has somenting like
select * project where key not in(select(pkey) from jiraisue where updated is less then 6 months ago.
so have dynamic range...
@maarten breesnee Did you ever get this to work?
@PADMA KOTHAKOTA Can you please provide the correct syntax for the SQL command. Also, is the db schema the same regardless of which database we are usinng? For example, Postgres vs mySql
It looks like you're new here. Sign in or register to get started.
