VbzCart/queries/qryTitles ItTyps ItTyps - Revision history

Woozle: corrections

2011-01-24T19:20:09Z

corrections

← Older revision		Revision as of 19:20, 24 January 2011
Line 1:		Line 1:
	==About==		==About==
	* '''Returns''': list of available titles for each item type		* '''Returns''': list of available titles for each item type
	** This query ~~generally~~ provides the same information as {{vbzcart\|table\|_title_ittyps}}, but ~~uses live~~ (~~non-cached~~) data.		** This query provides some of the same information as {{vbzcart\|table\|_title_ittyps}}, but (a) broken down by Item and (b) using live data.
	** There is probably some function-overlap between this query and the procedures which build that cached table.
	* '''Requires''': {{vbzcart/query\|qryTitles_ItTyps_grpItems}}, {{vbzcart/table\|cat_ittyps}}		* '''Requires''': {{vbzcart/query\|qryTitles_ItTyps_grpItems}}, {{vbzcart/table\|cat_ittyps}}
	* '''Used by''': can be used by catalog ~~title~~ pages, but is very slow; currently no known uses		* '''Used by''': can be used by catalog pages in place of cat_items to provide realtime data (instead of relying on some cached fields in cat_items), but this is very slow; currently no known uses.
	* '''History''':		* '''History''':
	** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed		** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed
	** '''2011-01-24''' For consistency with {{vbzcart\|table\|_title_ittyps}} ~~so that they may be used interchangeably~~:		** '''2011-01-24''' For consistency with {{vbzcart\|table\|_title_ittyps}}:
	*** '''ItTyp_Sort''' → '''ItTypSort'''		*** '''ItTyp_Sort''' → '''ItTypSort'''
	*** '''ItTyp_Sng''' → '''ItTypNameSng'''		*** '''ItTyp_Sng''' → '''ItTypNameSng'''

Woozle: changing field names for compatibility with cached table

2011-01-24T17:15:38Z

changing field names for compatibility with cached table

← Older revision		Revision as of 17:15, 24 January 2011
Line 1:		Line 1:
	==About==		==About==
			* '''Returns''': list of available titles for each item type
			** This query generally provides the same information as {{vbzcart\|table\|_title_ittyps}}, but uses live (non-cached) data.
			** There is probably some function-overlap between this query and the procedures which build that cached table.
	* '''Requires''': {{vbzcart/query\|qryTitles_ItTyps_grpItems}}, {{vbzcart/table\|cat_ittyps}}		* '''Requires''': {{vbzcart/query\|qryTitles_ItTyps_grpItems}}, {{vbzcart/table\|cat_ittyps}}
	* '''Used by''': catalog title pages		* '''Used by''': can be used by catalog title pages, but is very slow; currently no known uses
	* '''History''':		* '''History''':
	** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed		** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed
			** '''2011-01-24''' For consistency with {{vbzcart\|table\|_title_ittyps}} so that they may be used interchangeably:
			*** '''ItTyp_Sort''' → '''ItTypSort'''
			*** '''ItTyp_Sng''' → '''ItTypNameSng'''
			*** '''ItTyp_Plr''' → '''ItTypNamePlr'''
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS
	SELECT		SELECT
	i.*,		i.*,
	it.Sort AS ~~ItTyp_Sort~~,		it.Sort AS ItTypSort,
	it.NameSng AS ~~ItTyp_Sng~~,		it.NameSng AS ItTypNameSng,
	IFNULL(it.NamePlr,it.NameSng) AS ~~ItTyp_Plr~~		IFNULL(it.NamePlr,it.NameSng) AS ItTypNamePlr
	FROM		FROM
	qryTitles_ItTyps_grpItems AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID;</mysql>		qryTitles_ItTyps_grpItems AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID;</mysql>
	<section end=sql />		<section end=sql />

Woozle: some documentation

2009-04-13T12:33:31Z

some documentation

← Older revision		Revision as of 12:33, 13 April 2009
Line 1:		Line 1:
			==About==
			* '''Requires''': {{vbzcart/query\|qryTitles_ItTyps_grpItems}}, {{vbzcart/table\|cat_ittyps}}
			* '''Used by''': catalog title pages
			* '''History''':
			** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS

Woozle: moved from single-page listing

2008-11-30T18:38:27Z

moved from single-page listing

New page

==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS
SELECT
i.*,
it.Sort AS ItTyp_Sort,
it.NameSng AS ItTyp_Sng,
IFNULL(it.NamePlr,it.NameSng) AS ItTyp_Plr
FROM
qryTitles_ItTyps_grpItems AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID;</mysql>
<section end=sql />