VbzCart/docs/queries/qryCbx Orders: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==Details== * '''Requires''': core_orders * '''Used by''': various forms, I think * '''Fields''': ** '''ID_Pull''' and '''WhenNeeded''' are needed for [[../qry...) |
imported>Woozle 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 | ||
Revision as of 18:17, 9 July 2009
About
- Requires: Template:Vbzcart
- Used by: various forms, I think
- Fields:
- ID_Pull and WhenNeeded are needed for Template:Vbzcart/query
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 />