VbzCart/queries/qryRstkReq by PurchOrd - Revision history

Woozle: /* SQL */ corrected name of query in SQL

2008-12-22T18:55:40Z

SQL: corrected name of query in SQL

← Older revision		Revision as of 18:55, 22 December 2008
Line 5:		Line 5:
	** '''2008-12-22''' Adapted from the [[../discarded\|discarded]] query qryCbxRestock_by_PurchOrd		** '''2008-12-22''' Adapted from the [[../discarded\|discarded]] query qryCbxRestock_by_PurchOrd
	==SQL==		==SQL==
	<mysql>CREATE OR REPLACE VIEW ~~qryCbx_RstkReq_by_PurchOrd~~ AS		<mysql>CREATE OR REPLACE VIEW qryRstkReq_by_PurchOrd AS
	SELECT		SELECT
	r.ID,		r.ID,

Woozle: updated name of the query this is used for

2008-12-22T18:54:16Z

updated name of the query this is used for

← Older revision		Revision as of 18:54, 22 December 2008
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': One of two queries which are [[SQL/UNION\|UNION]]ed to create {{vbzcart/query\|~~qryRstkReq~~}}		* '''Purpose''': One of two queries which are [[SQL/UNION\|UNION]]ed to create {{vbzcart/query\|qryCbx_RstkReq}}
	* '''Requires''': {{vbzcart/table\|rstk_req}}		* '''Requires''': {{vbzcart/table\|rstk_req}}
	* '''History''':		* '''History''':

Woozle: New page: ==About== * '''Purpose''': One of two queries which are UNIONed to create {{vbzcart/query|qryRstkReq}} * '''Requires''': {{vbzcart/table|rstk_req}} * '''History''': ** '''200...

2008-12-22T18:43:38Z

New page: ==About== * '''Purpose''': One of two queries which are UNIONed to create {{vbzcart/query|qryRstkReq}} * '''Requires''': {{vbzcart/table|rstk_req}} * '''History''': ** '''200...

New page

==About==
* '''Purpose''': One of two queries which are [[SQL/UNION|UNION]]ed to create {{vbzcart/query|qryRstkReq}}
* '''Requires''': {{vbzcart/table|rstk_req}}
* '''History''':
** '''2008-12-22''' Adapted from the [[../discarded|discarded]] query qryCbxRestock_by_PurchOrd
==SQL==
<mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq_by_PurchOrd AS
SELECT
r.ID,
CAST(r.PurchOrdNum AS CHAR) AS Descr,
NOT IsLocked AS IsOpen,
r.WhenOrdered,
r.WhenConfirmed,
r.ID_Supplier
FROM rstk_req AS r WHERE r.PurchOrdNum IS NOT NULL
ORDER BY COALESCE(r.WhenKilled,r.WhenOrdered,r.WhenCreated) DESC;</mysql>