VbzCart/docs/queries/qryStk History: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(+ORDER BY ID)
imported>Woozle
(dropped)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': {{vbzcart/table|stk_history}} plus {{vbzcart/table|stk_history_legacy}} data, if any, with IDs adjusted to prevent duplicates. Lets you see the complete history including legacy stuff, without polluting the main log with non-fixable legacy data.
* '''Status''': No longer functional; dropped. Legacy data was merged into revised {{l/vc/table|stk_history}}.
* '''Purpose''': {{l/vc/table|stk_history}} plus {{l/vc/table|stk_history_legacy}} data, if any, with IDs adjusted to prevent duplicates. Lets you see the complete history including legacy stuff, without polluting the main log with non-fixable legacy data.
* '''History''':
* '''History''':
** '''2008-12-29''' Created
** '''2008-12-29''' Created
** '''2008-12-30''' Added "ORDER BY ID" so everything will be in sequence (apparently ORDER BY is assumed to refer to the whole UNION, and can't be used within the individual SELECTs that go into the UNION)
** '''2008-12-30''' Added "ORDER BY ID" so everything will be in sequence (apparently ORDER BY is assumed to refer to the whole UNION, and can't be used within the individual SELECTs that go into the UNION)
** '''2016-03-03''' Dropped.
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_History AS
<mysql>CREATE OR REPLACE VIEW qryStk_History AS
SELECT * FROM stk_history
SELECT * FROM stk_history
UNION
UNION
Line 27: Line 29:
   FROM stk_history_legacy
   FROM stk_history_legacy
ORDER BY ID;</mysql>
ORDER BY ID;</mysql>
<section end=sql />

Revision as of 23:04, 3 March 2016

About

  • Status: No longer functional; dropped. Legacy data was merged into revised Template:L/vc/table.
  • Purpose: Template:L/vc/table plus Template:L/vc/table data, if any, with IDs adjusted to prevent duplicates. Lets you see the complete history including legacy stuff, without polluting the main log with non-fixable legacy data.
  • History:
    • 2008-12-29 Created
    • 2008-12-30 Added "ORDER BY ID" so everything will be in sequence (apparently ORDER BY is assumed to refer to the whole UNION, and can't be used within the individual SELECTs that go into the UNION)
    • 2016-03-03 Dropped.

SQL

<mysql>CREATE OR REPLACE VIEW qryStk_History AS SELECT * FROM stk_history UNION SELECT 

 CAST(ID-5000 AS SIGNED) AS ID,
 ID_StkBin,
 ID_StkLine,
 CH_OthType,
 ID_OthCont,
 ID_OthLine,
 IDS_OthCont,
 ID_Item,
 QtyBefore,
 QtyAdded,
 QtyAfter,
 QtyBinBefore,
 QtyBinAfter,
 `When`,
 What,
 Notes
 FROM stk_history_legacy

ORDER BY ID;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryStk_History&oldid=5351"