https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryOrderLines_ActiveVbzCart/queries/qryOrderLines Active - Revision history2026-08-23T12:31:36ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/qryOrderLines_Active&diff=10912&oldid=prevWoozle: New page: ==Details== * '''Returns''': all order lines for orders which are currently active as determined by qryOrders_Active. * '''Requires''': {{vbzcart/table|ord_lines}},...2008-12-03T21:11:01Z<p>New page: ==Details== * '''Returns''': all order lines for orders which are currently active as determined by [[../qryOrders_Active|qryOrders_Active]]. * '''Requires''': {{vbzcart/table|ord_lines}},...</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Returns''': all order lines for orders which are currently active as determined by [[../qryOrders_Active|qryOrders_Active]].<br />
* '''Requires''': {{vbzcart/table|ord_lines}}, [[../qryOrders_Active|qryOrders_Active]]<br />
* '''Used by''': [[../qryOrdItms_Pkg_qtys|qryOrdItms_Pkg_qtys]]<br />
* '''History''':<br />
** '''2008-11-16''' created for new restocking process<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryOrderLines_Active AS<br />
SELECT ol.* FROM ord_lines AS ol LEFT JOIN qryOrders_Active AS o ON ol.ID_Order=o.ID<br />
WHERE o.ID IS NOT NULL;</mysql><br />
<section end=sql /></div>Woozle