VbzCart/docs/queries/qryRstkReq by PurchOrd: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (→SQL: corrected name of query in SQL) |
m (Woozle moved page VbzCart/VbzCart/queries/qryRstkReq by PurchOrd to VbzCart/docs/queries/qryRstkReq by PurchOrd without leaving a redirect: part 3/5) |
(No difference)
| |
Latest revision as of 01:56, 25 February 2024
About
- Purpose: One of two queries which are UNIONed to create Template:Vbzcart/query
- Requires: Template:Vbzcart/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>