How to find new projects in Jira( interval of six months)??

[Raju Anumula]

Hi Team,

How to find new projects in Jira(particular interval), I believe it is possible to get a list from the database.

Can you help me to get a list of new project in the time period of six months, we are using Postgres database.

Thanks in Advance.

[Mesut Yilmazyildirim]

There's no entry of project creation on DB.  

The best way will be to look at the dates of the first created issue (if there is one).  
If you don't have any issues in it, then the last resort is the project ID - these always go up, although they're not contiguous.  

Below query can give you some idea;

SELECT *
 FROM jirasd.project
 WHERE ID IN 
 (
   SELECT DISTINCT (project)
   FROM jirasd.jiraissue
   WHERE created > TO_DATE ('01/01/18', 'DD/MM/YY')
  );