Search for projects created after a certain date

[Ventsislav]

Hello,

I am looking for a way to find a project that was created after a certain date using Python.

Is there a JQL query that would do something like:

Select * from project where date > '05/08/2020'

I believe the search endpoint is related only to issues?

[Nic Brough -Adaptavist- · Accepted solution]

Correct, JQL finds issues.

Projects do not have their creation date recorded, so even your SQL wouldn't work if you could use it.  (the admin audit log gets a line, but those are transient - only kept for a while and cleared down when they're a bit old)

The best you can do is look at "created" on the oldest issue in the project, that tells you when the project was first used, which in most places will be within a couple of working days of project creation.

[deborah duffy]

Could you give an example of jql that would return the oldest issue of a project? 

Having the created date stored and queryable would help us with budget and forecast. I think this basic project meta data should be available. 

Also, although the audit log does show the project creation (for the past 6 months, as currently set), the search box does not respond as expected to "Project created".

The results returned are the same as if the content of the search box was "created", so it returns a lot of irrelevant lines. 

Thank you for your help and knowledge of how this works