VbzCart/queries/qryStk items remaining - Revision history

Woozle: another user

2011-01-24T01:55:48Z

another user

← Older revision		Revision as of 01:55, 24 January 2011
Line 2:		Line 2:
	* '''Returns''': Same records as {{vbzcart/query\|qryStk_lines_remaining}}, but grouped by Item		* '''Returns''': Same records as {{vbzcart/query\|qryStk_lines_remaining}}, but grouped by Item
	* '''Requires''': {{vbzcart/query\|qryStk_lines_remaining}}		* '''Requires''': {{vbzcart/query\|qryStk_lines_remaining}}
	* '''Used by''': {{vbzcart/query\|qryCat_Items_Stock}}		* '''Used by''': {{vbzcart/query\|qryCat_Items_Stock}}, {{vbzcart\|proc\|Upd_TitleIttyps_fr_CatItems_Titles}}
	* '''History''':		* '''History''':
	** '''2009-11-29''' Renamed from '''v_stk_items_remaining''' to '''qryStk_items_remaining'''; also underlying query renamed		** '''2009-11-29''' Renamed from '''v_stk_items_remaining''' to '''qryStk_items_remaining'''; also underlying query renamed

Woozle: post-move update; also name of underlying query changed

2009-11-29T23:21:43Z

post-move update; also name of underlying query changed

← Older revision		Revision as of 23:21, 29 November 2009
Line 1:		Line 1:
	==Details==		==Details==
	* '''Returns''': Same records as {{vbzcart/query\|~~v_stk_lines_remaining~~}}, but grouped by Item		* '''Returns''': Same records as {{vbzcart/query\|qryStk_lines_remaining}}, but grouped by Item
	* '''Requires''': {{vbzcart/query\|~~v_stk_lines_remaining~~}}		* '''Requires''': {{vbzcart/query\|qryStk_lines_remaining}}
	* '''Used by''':		* '''Used by''': {{vbzcart/query\|qryCat_Items_Stock}}
			* '''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 ~~v_stk_items_remaining~~ AS		<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 ~~v_stk_lines_remaining~~		FROM qryStk_lines_remaining
	GROUP BY ID_Item;</mysql>		GROUP BY ID_Item;</mysql>
	<section end=sql />		<section end=sql />

Woozle: moved VbzCart/queries/v stk items remaining to VbzCart/queries/qryStk items remaining: time to rebuild this one too...

2009-11-29T23:08:01Z

moved VbzCart/queries/v stk items remaining to VbzCart/queries/qryStk items remaining: time to rebuild this one too...

← Older revision	Revision as of 23:08, 29 November 2009
(No difference)

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=...

2008-12-04T01:54:51Z

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=...

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==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_items_remaining AS
SELECT
ID_Item,
SUM(QtyForSale) AS QtyForSale,
SUM(QtyForShip) AS QtyForShip,
SUM(QtyExisting) AS QtyExisting
FROM v_stk_lines_remaining
GROUP BY ID_Item;</mysql>
<section end=sql />