https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryOrders_Pulled
VbzCart/queries/qryOrders Pulled - Revision history
2026-07-07T11:51:37Z
Revision history for this page on the wiki
MediaWiki 1.45.3
https://htyp.org/mw/index.php?title=VbzCart/queries/qryOrders_Pulled&diff=12000&oldid=prev
Woozle: usage correction
2009-07-10T13:26:03Z
<p>usage correction</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:26, 10 July 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==About==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==About==</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Used by''': {{vbzcart|<del style="font-weight: bold; text-decoration: none;">table|ord_msg</del>}}</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Used by''': {{vbzcart<ins style="font-weight: bold; text-decoration: none;">/query</ins>|<ins style="font-weight: bold; text-decoration: none;">qryPkgs_Pull_status</ins>}}</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''History''':</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''History''':</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>** '''2009-07-10''' Adapted from MS Access (replaces qryOrderPulls_active)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>** '''2009-07-10''' Adapted from MS Access (replaces qryOrderPulls_active)</div></td></tr>
</table>
Woozle
https://htyp.org/mw/index.php?title=VbzCart/queries/qryOrders_Pulled&diff=11996&oldid=prev
Woozle: New page: ==About== * '''Used by''': {{vbzcart|table|ord_msg}} * '''History''': ** '''2009-07-10''' Adapted from MS Access (replaces qryOrderPulls_active) *** qryOrderPulls_active derived its list o...
2009-07-10T12:53:28Z
<p>New page: ==About== * '''Used by''': {{vbzcart|table|ord_msg}} * '''History''': ** '''2009-07-10''' Adapted from MS Access (replaces qryOrderPulls_active) *** qryOrderPulls_active derived its list o...</p>
<p><b>New page</b></p><div>==About==<br />
* '''Used by''': {{vbzcart|table|ord_msg}}<br />
* '''History''':<br />
** '''2009-07-10''' Adapted from MS Access (replaces qryOrderPulls_active)<br />
*** qryOrderPulls_active derived its list of pulled orders from {{vbzcart|table|ord_pull}}; qryOrders_Pulled lists all core_orders where ID_Pull is set<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryOrders_Pulled AS<br />
SELECT<br />
op.*<br />
FROM core_orders AS o LEFT JOIN ord_pull AS op<br />
ON o.ID_Pull=op.ID<br />
WHERE o.ID_Pull IS NOT NULL;</mysql><br />
<section end=sql /></div>
Woozle