Difference between revisions of "VbzCart/queries/qryCbx Orders"
Jump to navigation
Jump to search
(New page: ==Details== * '''Requires''': core_orders * '''Used by''': various forms, I think * '''Fields''': ** '''ID_Pull''' and '''WhenNeeded''' are needed for [[../qry...) |
m (minor doc formatting updates) |
||
| Line 1: | Line 1: | ||
| − | == | + | ==About== |
| − | * '''Requires''': | + | * '''Requires''': {{vbzcart|table|core_orders}} |
* '''Used by''': various forms, I think | * '''Used by''': various forms, I think | ||
* '''Fields''': | * '''Fields''': | ||
| − | ** '''ID_Pull''' and '''WhenNeeded''' are needed for | + | ** '''ID_Pull''' and '''WhenNeeded''' are needed for {{vbzcart/query|qryStock_forOpenOrders}} |
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Orders AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Orders AS | ||
Latest revision as of 18:17, 9 July 2009
About
- Requires: core_orders
- Used by: various forms, I think
- Fields:
- ID_Pull and WhenNeeded are needed for
- REDIRECT Template:l/vc/query
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>