VbzCart/queries/qryCbx Orders
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Requires: core_orders
- Used by: various forms, I think
- Fields:
- ID_Pull and WhenNeeded are needed for qryStock_forOpenOrders
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Orders AS SELECT
ID,
CONCAT_WS(' due ',CAST(Number AS CHAR),DATE_FORMAT(WhenNeeded,'%Y-%m-%d')) AS Descr,
ID_Pull,
WhenNeeded
FROM core_orders ORDER BY CONCAT(IFNULL(SortPfx,),Number) DESC;</mysql> <section end=sql />
