Database Production View needs "Quantity" Field

[adamj537]

The PostgreSQL database used in MESS contains several database views. One of the views is called the "Production View." This view is designed for calculating First Pass Yield, but it would be more useful if it also included a column for quantity of product produced.

[Paritoshcodes]

Hey @adamj537 I would like to work on this issue.

[adamj537]

Ok, go for it! I'm here if you need help. Please do work in a fork and submit a pull request when finished.

[adamj537]

@EyeBrawler since Batch Mode produces multiple Production Logs (one for each part in the batch), and this view shows each Production Log, is the quantity of parts produced always 1?

[EyeBrawler]

Yes, the quantity of parts produced for each production log will always be 1 (or 0 once we introduce rework or a production log failing to produce a part). This value is not stored explicitly as it can be inferred from the data. On the other hand, the FromBatchOf field is stored explicitly and should probably be displayed in the production view if it is not already.