VbzCart/docs/queries/qryCtg Titles active: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(added to main server database)
imported>Woozle
No edit summary
Line 4: Line 4:
* '''History''':
* '''History''':
** '''2009-05-03''' Added to main server database (no change in design)
** '''2009-05-03''' Added to main server database (no change in design)
** '''2016-03-02''' This query no longer works, and (coincidentally) should no longer be needed.
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS
<mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS
   SELECT
   SELECT
     *
     *
Line 17: Line 18:
       )
       )
     );</mysql>
     );</mysql>
<section end=sql />

Revision as of 22:39, 2 March 2016

Details

  • Purpose: Brings up only Template:Vbzcart records which are active, making it impossible for an inactive catalog to make an active title look inactive.
  • Requires: Template:Vbzcart
  • History:
    • 2009-05-03 Added to main server database (no change in design)
    • 2016-03-02 This query no longer works, and (coincidentally) should no longer be needed.

SQL

<mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS 

 SELECT
   *
 FROM ctg_titles AS tgt
 WHERE 
   tgt.isActive
   AND
   ( ( tgt.WhenDiscont Is Null
      ) Or (
       tgt.WhenDiscont>Now()
      )
    );</mysql>
Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryCtg_Titles_active&oldid=5223"