VbzCart/docs/queries/qryStk items remaining: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==Details== * '''Returns''': Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Item * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}} * '''Used by''': ==SQL=...) |
m (Woozle moved page VbzCart/VbzCart/queries/qryStk items remaining to VbzCart/docs/queries/qryStk items remaining without leaving a redirect: part 3/5) |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Details== | ==Details== | ||
* '''Returns''': Same records as {{vbzcart/query| | * '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item | ||
* '''Requires''': {{vbzcart/query| | * '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | ||
* '''Used by''': | * '''Used by''': {{vbzcart/query|qryCat_Items_Stock}}, {{vbzcart|proc|Upd_TitleIttyps_fr_CatItems_Titles}} | ||
* '''History''': | |||
** '''2009-11-29''' Renamed from '''v_stk_items_remaining''' to '''qryStk_items_remaining'''; also underlying query renamed | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_items_remaining AS | ||
SELECT | SELECT | ||
ID_Item, | ID_Item, | ||
| Line 10: | Line 12: | ||
SUM(QtyForShip) AS QtyForShip, | SUM(QtyForShip) AS QtyForShip, | ||
SUM(QtyExisting) AS QtyExisting | SUM(QtyExisting) AS QtyExisting | ||
FROM | FROM qryStk_lines_remaining | ||
GROUP BY ID_Item;</mysql> | GROUP BY ID_Item;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Latest revision as of 01:56, 25 February 2024
Details
- Returns: Same records as Template:Vbzcart/query, but grouped by Item
- Requires: Template:Vbzcart/query
- Used by: Template:Vbzcart/query, Template:Vbzcart
- History:
- 2009-11-29 Renamed from v_stk_items_remaining to qryStk_items_remaining; also underlying query renamed
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_items_remaining AS
SELECT ID_Item, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM qryStk_lines_remaining GROUP BY ID_Item;</mysql>
<section end=sql />