VbzCart/queries/qryRstkReq by PurchOrd

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 18:55, 22 December 2008 by Woozle (talk | contribs) (→‎SQL: corrected name of query in SQL)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Purpose: One of two queries which are UNIONed to create
  1. REDIRECT Template:l/vc/query
  • Requires:
  1. 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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryRstkReq_by_PurchOrd&oldid=11040"