Woozle: Created page with '==About== * '''Purpose''': Returns all restock requests which are no longer active, for historical uses; the exact opposite of {{vbzcart/query|qryRstks_active}}. * '''Requires'''…'

2010-01-03T15:23:31Z

Created page with '==About== * '''Purpose''': Returns all restock requests which are no longer active, for historical uses; the exact opposite of {{vbzcart/query|qryRstks_active}}. * '''Requires'''…'

New page

==About==
* '''Purpose''': Returns all restock requests which are no longer active, for historical uses; the exact opposite of {{vbzcart/query|qryRstks_active}}.
* '''Requires''': {{vbzcart/table|rstk_req}}
* '''Used by''': admin listing of closed restock requests
* '''History''':
** '''2010-01-03''' Created for admin listing of closed restock requests
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstks_inactive AS
SELECT rq.* FROM rstk_req AS rq
WHERE (rq.WhenClosed IS NOT NULL) OR (rq.WhenKilled IS NOT NULL) OR (rq.WhenOrphaned IS NOT NULL);</mysql>
<section end=sql />

VbzCart/queries/qryRstks inactive - Revision history

Woozle: Created page with '==About== * '''Purpose''': Returns all restock requests which are no longer active, for historical uses; the exact opposite of {{vbzcart/query|qryRstks_active}}. * '''Requires'''…'