Difference between revisions of "VbzCart/queries/qryRstks active"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(New page: ==Details== * '''Returns''': List of restock requests for which we are currently expecting one or more shipments * '''Requires''': {{vbzcart/table|rstk_req}} * '''Used by''': * '''History'...)
 
(→‎Details: used by (2 queries))
Line 2: Line 2:
 
* '''Returns''': List of restock requests for which we are currently expecting one or more shipments
 
* '''Returns''': List of restock requests for which we are currently expecting one or more shipments
 
* '''Requires''': {{vbzcart/table|rstk_req}}
 
* '''Requires''': {{vbzcart/table|rstk_req}}
* '''Used by''':
+
* '''Used by''': {{vbzcart/query|qryRstkItms_active}}, {{vbzcart/query|qryRstks_unsent}}
 
* '''History''':
 
* '''History''':
 
** '''2008-11-19''' Created for new restock process
 
** '''2008-11-19''' Created for new restock process
Line 9: Line 9:
 
** We don't want to exclude requests just because a shipment has been received, because that shipment might not have included everything in the request. Once a request is marked closed (via '''WhenClosed'''), however, it means we are not expecting any further receipts from that request and we will need to request again if there's anything not yet received.
 
** We don't want to exclude requests just because a shipment has been received, because that shipment might not have included everything in the request. Once a request is marked closed (via '''WhenClosed'''), however, it means we are not expecting any further receipts from that request and we will need to request again if there's anything not yet received.
 
** At one point, doing a JOIN with rstk_rcd seemed to make the query run faster, but this may have been an illusion due to caching by MySQL and not enough testing.
 
** At one point, doing a JOIN with rstk_rcd seemed to make the query run faster, but this may have been an illusion due to caching by MySQL and not enough testing.
 +
 
==SQL==
 
==SQL==
 
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstks_active AS
 
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstks_active AS

Revision as of 01:46, 5 December 2008

Details

  • Returns: List of restock requests for which we are currently expecting one or more shipments
  • Requires:
  1. REDIRECT Template:l/vc/table
  • Used by:
  1. REDIRECT Template:l/vc/query, qryRstks_unsent
  • History:
    • 2008-11-19 Created for new restock process
    • 2008-11-20 Including WhenClosed (new field) in the filter
  • Notes:
    • We don't want to exclude requests just because a shipment has been received, because that shipment might not have included everything in the request. Once a request is marked closed (via WhenClosed), however, it means we are not expecting any further receipts from that request and we will need to request again if there's anything not yet received.
    • At one point, doing a JOIN with rstk_rcd seemed to make the query run faster, but this may have been an illusion due to caching by MySQL and not enough testing.

SQL

<mysql>CREATE OR REPLACE VIEW qryRstks_active AS

 SELECT rq.* FROM rstk_req AS rq
   WHERE (rq.WhenClosed IS NULL) AND (rq.WhenKilled IS NULL) AND (rq.WhenOrphaned IS NULL);</mysql>