VbzCart/queries/qryRstkItms expected byItem: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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…' |
No edit summary |
||
| 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== | ||
<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> | ||
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: qryRstkItms_expected
- Used by : restock request generation admin page
- History:
- 2010-01-05 Created for VbzAdmin; replaced qryRstkReq_Items_expected
- 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>
