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.
Hi Erik,
is your question about Bitbucket or Bitbucket Server?
Cheers,
Christian
Premier Support Engineer
Atlassian
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.