https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryPkgLines_byOrdLine_andItem
VbzCart/queries/qryPkgLines byOrdLine andItem - Revision history
2026-07-01T12:49:23Z
Revision history for this page on the wiki
MediaWiki 1.45.3
https://htyp.org/mw/index.php?title=VbzCart/queries/qryPkgLines_byOrdLine_andItem&diff=10925&oldid=prev
Woozle: New page: ==Details== * '''Requires''': {{vbzcart/table|ord_pkg_lines}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryPkgLines_byOrdLine_andItem AS SELECT ID_OrdLi...
2008-12-03T23:41:46Z
<p>New page: ==Details== * '''Requires''': {{vbzcart/table|ord_pkg_lines}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryPkgLines_byOrdLine_andItem AS SELECT ID_OrdLi...</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Requires''': {{vbzcart/table|ord_pkg_lines}}<br />
* '''Used by''':<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryPkgLines_byOrdLine_andItem AS<br />
SELECT<br />
ID_OrdLine,<br />
ID_Item,<br />
Sum(<br />
IFNULL(pl.QtyShipped,0)+<br />
IFNULL(pl.QtyNotAvail,0)+<br />
IFNULL(pl.QtyKilled,0)<br />
) AS QtyDone,<br />
Sum(pl.QtyShipped) AS QtyShipped,<br />
Sum(pl.QtyNotAvail) AS QtyNotAvail,<br />
Sum(pl.QtyKilled) AS QtyKilled,<br />
Sum(pl.QtyExtra) AS QtyExtra<br />
FROM ord_pkg_lines AS pl<br />
GROUP BY ID_OrdLine, ID_Item;</mysql><br />
<section end=sql /></div>
Woozle