Project Creation Date

[Deleted user]

Greetings,

As topic name mentiones, is it possible to extract through REST or DB project creation time? We would like to monitor amount of private repositories and sort them by creation date. Thank you.

[Christian Glockner · Accepted solution]

Hi Erik,

is your question about Bitbucket or Bitbucket Server?

Cheers,

Christian

Premier Support Engineer

Atlassian

[Deleted user]

Greetings, Christian.

Bitbucket Data Center hosted in AWS.

[Christian Glockner]

Hi Erik,

There is no way to do this via the REST API, but the following query on the database should give you this information:

SELECT p.name, pa.DATE from project p, AO_BD73C3_PROJECT_AUDIT pa WHERE p.id = pa.PROJECT_ID AND pa.ACTION='ProjectCreatedEvent'

Cheers,

Christian

Premier Support Engineer

Atlassian

[Deleted user]

Thank you for example.

[Deleted user]

Hmm, I'm getting followin error, despite I see this table in pgAdmin

ERROR: relation "ao_bd73c3_project_audit" does not exist

Will try to investigate myself too.

[Deleted user]

solved: double quotes needed for pgAdmin. Thanks again.

[Serkan Dik]

Surely the .../rest/api/3/project/ endpoint could easily be enhanced to return create date?

Infact, it should support a filter to search project by create date!!!