Woozle: alternate version

2008-12-03T21:09:24Z

alternate version

← Older revision		Revision as of 21:09, 3 December 2008
Line 13:		Line 13:
	(WhenClosed IS NULL);</mysql>		(WhenClosed IS NULL);</mysql>
	<section end=sql />		<section end=sql />
			==alternate version==
			* '''Purpose''': This version ignores the WhenClosed field, so we can check that no orders have been marked closed when they still have open items. Use temporarily for data remediation only, then restore to normal version.
			* '''History''':
			** '''2008-11-21''' Created because it looks like the Massive Order Closing closed ''all'' orders that were open.
			<mysql>CREATE OR REPLACE VIEW qryOrders_Active AS
			SELECT * FROM core_orders
			WHERE
			(ID_Pull IS NULL);</mysql>

Woozle: New page: ==Details== * '''Returns''': all orders which are currently active. For now, this just shows orders which haven't been pulled , but later it will look at the order state. As simple as it i...

2008-12-03T21:08:06Z

New page: ==Details== * '''Returns''': all orders which are currently active. For now, this just shows orders which haven't been pulled , but later it will look at the order state. As simple as it i...

New page

==Details==
* '''Returns''': all orders which are currently active. For now, this just shows orders which haven't been pulled , but later it will look at the order state. As simple as it is, it's still useful to have this as a separate query because:
** Removing unneeded records before sending data helps to reduce bandwidth a little bit when called from a remote process
** Serves as a reference which can be used unaltered even after the method of determining whether an order is "active" changes
* '''Requires''': {{vbzcart/table|core_orders}}
* '''History''':
** '''2008-11-20''' Added requirement that '''WhenClosed''' (new field) must also be NULL
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryOrders_Active AS
SELECT * FROM core_orders
WHERE
(ID_Pull IS NULL) AND
(WhenClosed IS NULL);</mysql>
<section end=sql />

VbzCart/queries/qryOrders Active - Revision history

Woozle: alternate version

Woozle: New page: ==Details== * '''Returns''': all orders which are currently active. For now, this just shows orders which haven't been pulled , but later it will look at the order state. As simple as it i...