VbzCart/docs/queries/qryRstkItms expected byItem: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
No edit summary
 
(No difference)

Latest revision as of 01:55, 25 February 2024

About

  • Purpose: Returns a list of items we're currently expecting to receive in restocks,
  • Requires: Template:Vbzcart/query
  • Used by : restock request generation admin page
  • History:
    • 2010-01-05 Created for VbzAdmin; replaced Template:Vbzcart/query
    • 2016-03-02 No longer works; dropped from database.

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS SELECT 

 ID_Item,
 SUM(QtyExp) AS QtyExp,
 SUM(QtyRecd) AS QtyRecd

FROM qryRstkItms_expected GROUP BY ID_Item;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryRstkItms_expected_byItem&oldid=6793"