https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqtyOrderItems_ActiveVbzCart/queries/qtyOrderItems Active - Revision history2026-07-08T03:30:41ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/qtyOrderItems_Active&diff=10913&oldid=prevWoozle: New page: ==Details== * '''Returns''': Same as qryOrderLines_Active, but by Item instead of OrdLine (and leaving out extra info about items which might return multiple re...2008-12-03T21:14:12Z<p>New page: ==Details== * '''Returns''': Same as [[../qryOrderLines_Active|qryOrderLines_Active]], but by Item instead of OrdLine (and leaving out extra info about items which might return multiple re...</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Returns''': Same as [[../qryOrderLines_Active|qryOrderLines_Active]], but by Item instead of OrdLine (and leaving out extra info about items which might return multiple records due to slight differences)<br />
* '''Requires''': [[../qryOrderLines_Active|qryOrderLines_Active]]<br />
* '''Used by''': <br />
* '''Notes''': In theory, the same item should never appear on more than one line in an order -- but current data has two older records in which this actually did take place. This query provides order-line data consolidated by item, in case it happens again.<br />
* '''History''':<br />
** '''2008-11-16''' created for new restocking process<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryOrderItems_Active AS<br />
SELECT<br />
ID_Order,<br />
ID_Item,<br />
SUM(QtyOrd) AS QtyOrd,<br />
COUNT(ID) AS CountLines<br />
FROM qryOrderLines_Active GROUP BY ID_Order, ID_Item;</mysql><br />
<section end=sql /></div>Woozle