More formally track project start dates
I would like to start formally tracking project start dates. We need this information when for various queries, including some with results that end up in the topics and issues. It's also helpful for us to have access to this information when we're scheduling reviews, etc. Today, I make what is generally a very good guess at the start date using the `ActiveDate` from the `PeopleProjects` table in the FoundationDB. I specifically look for the earliest `ActiveDate` and assume that that's when the project started. As of 2023, this earliest `ActiveDate` is usually some time after the project has been created, but it actually reflects the date that the project was provisioned. Before 2023, we often added project leads to the system before the project was created, which means that the computed start date is based on _any_ relationship might predate project creation. In either case, I expect that a computed start date is at least close to the actual creation date. The creation process goes like this: 1. Proposal is created 1. Community/Creation review runs for a bit 1. Creation review is declared successful; the project is considered to exist at this point. 1. We click the "Create Project" button to initiate provisioning 1. Project committers are sent instructions to provide committer agreements 1. We receive the first committer agreement 1. Committer record are created in the FoundationDB 1. Infrastructure team creates the project resources. 2. At some point we loop back and set the project lead records after the committers have all been provisioned The actual start date is when we complete step 3. The computed start date is set at step 7. Usually there is a day or two difference, but we sometimes wait weeks for committers to do something and the Infrastructure Team's work queue may introduce additional lag. I would like to track the actual start date and have it included in the API data for every project. It would be great if we could configure the "Create Project" button to automagically set the project "start" date. The EMO should be able to edit the value. Adding a "start date" field in the `project` content type in the PMI feels like a natural home for this (but I defer to your judgement). /cc @mdelgado624 @carmendelgado
issue

Copyright © Eclipse Foundation AISBL. All rights reserved.     Privacy Policy | Terms of Use | Copyright Agent