Difference between revisions of "VbzCart/queries/qryRstkItms expected byItem"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(Created page with '==About== * '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, * '''Requires''': {{vbzcart/query|qryRstkItms_expected}} * '''Used by ''': re…')
 
 
Line 5: Line 5:
 
* '''History''':
 
* '''History''':
 
** '''2010-01-05''' Created for VbzAdmin; replaced {{vbzcart/query|qryRstkReq_Items_expected}}
 
** '''2010-01-05''' Created for VbzAdmin; replaced {{vbzcart/query|qryRstkReq_Items_expected}}
 +
** '''2016-03-02''' No longer works; dropped from database.
 
==SQL==
 
==SQL==
−
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS
+
<mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS
 
SELECT
 
SELECT
 
   ID_Item,
 
   ID_Item,
Line 13: Line 14:
 
FROM qryRstkItms_expected
 
FROM qryRstkItms_expected
 
GROUP BY ID_Item;</mysql>
 
GROUP BY ID_Item;</mysql>
−
<section end=sql />
 

Latest revision as of 22:57, 2 March 2016

About

  • Purpose: Returns a list of items we're currently expecting to receive in restocks,
  • Requires:
  1. REDIRECT Template:l/vc/query
  • Used by : restock request generation admin page
  • History:

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://htyp.org/mw/index.php?title=VbzCart/queries/qryRstkItms_expected_byItem&oldid=21755"