Submission Warehouse DatabaseThe Submission Warehouse Database is a MySQL database which tracks all submissions made by all users in your organisation. Every time a user clicks Confirm Submission Acceptance in the client, the information about the submission title, plan and devices is stored in the database. Reports access the database to reference the submission history of projects and it is also possible to browse the Submission Warehouse Database manually. In Submission Perspective, click the Submission Warehouse Database link to access the top-level view of the database. This Global view shows all projects that have at least one confirmed submission. Global-scoped reports (reporting across multiple projects) are available via links on the right hand side of the screen. Clicking on a project will take you to a Project view, where you can see all the plans and channels in which submissions for this project have been made. From this view, Project-scope reports are available, reporting on details of a particular project. Clicking a further level allows you to drill down into a particular submission, identified by a plan and a channel. From here, it is possible to see which builds were submitted, their packaged names, the devices each build supported and the current status of these builds. StatusBy selecting builds or individual devices, it is possible to change their status. In this way, it is possible to track when builds go live, are rejected, or any other arbitrary status you might define. To change the status of a project, build or device, select the project name, build name or device name, select a status in the drop-down menu and click Save.
How Submissions are RecordedThe submission Warehouse Database records all submissions confirmed in the Metaflow submissions client. Upon confirmation of a submission, an audit transaction is stored in the database. An audit is a single entry in the database. Information stored as an audit record includes the builds that were delivered, which devices they covered, the channel, date and time and the person who made the submission. When the user views a project-channel-plan entry in the submission warehouse database, the information presented represents the sum of all audits i.e. the cumulative total of all submissions made to that channel, under that plan, for the given project. This includes any backfills / resubmissions and represents the current state of submission to the channel. The sum of all audits is termed the aggregate. The aggregate view of a project-channel-plan is the default view. In order to view individual submissions, rather than the aggregate, drill down into the submission and click on the View Audit History link.(As shown Below)
Upon clicking on View Audit History, the user is presented with a chronological history of all submissions made to the channel and the devices supported with each submission. (As Shown Below) 
|