VbzCart/docs/queries/qryCtg Titles active: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (moved from single-page listing) |
m (Woozle moved page VbzCart/VbzCart/queries/qryCtg Titles active to VbzCart/docs/queries/qryCtg Titles active without leaving a redirect: part 2) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Details== | ==Details== | ||
* '''Purpose''': Brings up ''only'' | * '''Purpose''': Brings up ''only'' {{vbzcart|table|ctg_titles}} records which are active, making it impossible for an inactive catalog to make an active title look inactive. | ||
* '''Requires''': | * '''Requires''': {{vbzcart|table|ctg_titles}} | ||
* '''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== | ==SQL== | ||
<mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS | |||
SELECT | SELECT | ||
* | * | ||
| Line 15: | Line 18: | ||
) | ) | ||
);</mysql> | );</mysql> | ||
Latest revision as of 01:55, 25 February 2024
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>