Difference between revisions of "VbzCart/queries/qryRstkReq by PurchOrd"
Jump to navigation
Jump to search
(New page: ==About== * '''Purpose''': One of two queries which are UNIONed to create {{vbzcart/query|qryRstkReq}} * '''Requires''': {{vbzcart/table|rstk_req}} * '''History''': ** '''200...) |
(→SQL: corrected name of query in SQL) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Purpose''': One of two queries which are [[SQL/UNION|UNION]]ed to create {{vbzcart/query| | + | * '''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''': | ||
** '''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 | + | <mysql>CREATE OR REPLACE VIEW qryRstkReq_by_PurchOrd AS |
SELECT | SELECT | ||
r.ID, | r.ID, | ||
Latest revision as of 18:55, 22 December 2008
About
- Purpose: One of two queries which are UNIONed to create
- REDIRECT Template:l/vc/query
- Requires:
- REDIRECT Template:l/vc/table
- History:
- 2008-12-22 Adapted from the discarded query qryCbxRestock_by_PurchOrd
SQL
<mysql>CREATE OR REPLACE VIEW qryRstkReq_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>