VbzCart/queries/qryCat Titles - Revision history

Woozle: cat: deprecated

2012-03-09T17:53:06Z

cat: deprecated

← Older revision		Revision as of 17:53, 9 March 2012
Line 1:		Line 1:
			[[category:VbzCart/deprecated]]
	==Details==		==Details==
	* '''Status''': DEPRECATED -- does not retrieve titles that have no department. Departments are being discontinued, so this is a problem.		* '''Status''': DEPRECATED -- does not retrieve titles that have no department. Departments are being discontinued, so this is a problem.

Woozle: deprecated

2012-03-05T15:56:29Z

deprecated

← Older revision		Revision as of 15:56, 5 March 2012
Line 1:		Line 1:
	==Details==		==Details==
			* '''Status''': DEPRECATED -- does not retrieve titles that have no department. Departments are being discontinued, so this is a problem.
	* '''Requires''': {{vbzcart\|table\|cat_titles}}, {{vbzcart/query\|qryCat_Depts}}		* '''Requires''': {{vbzcart\|table\|cat_titles}}, {{vbzcart/query\|qryCat_Depts}}
	* '''Fields''':		* '''Fields''':
Line 6:		Line 7:
	** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query		** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query
	** '''2011-01-29''' Added "t.Desc AS Descr" and "t.Search" to help with searching; t.Desc should eventually be renamed to t.Descr because "DESC" is an SQL keyword		** '''2011-01-29''' Added "t.Desc AS Descr" and "t.Search" to help with searching; t.Desc should eventually be renamed to t.Descr because "DESC" is an SQL keyword
			** '''2012-03-05''' DEPRECATED - should be removed from database and all pages checked to make sure they still work
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS

Woozle: t.Search, duh

2011-01-29T18:53:52Z

t.Search, duh

← Older revision		Revision as of 18:53, 29 January 2011
Line 5:		Line 5:
	* '''History''':		* '''History''':
	** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query		** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query
	** '''2011-01-29''' Added "t.Desc AS Descr" to help with searching; t.Desc should eventually be renamed to t.Descr because "DESC" is an SQL keyword		** '''2011-01-29''' Added "t.Desc AS Descr" and "t.Search" to help with searching; t.Desc should eventually be renamed to t.Descr because "DESC" is an SQL keyword
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS
Line 12:		Line 12:
	t.Name,		t.Name,
	t.Desc AS Descr,		t.Desc AS Descr,
			t.Search,
	UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,		UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
	LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,		LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,

Woozle: Descr field

2011-01-29T18:42:31Z

Descr field

← Older revision		Revision as of 18:42, 29 January 2011
Line 1:		Line 1:
	==Details==		==Details==
	* '''Requires''': ~~[[../../tables/cat_titles~~\|cat_titles]], ~~[[..~~/~~qryCat_Depts~~\|qryCat_Depts]]		* '''Requires''': {{vbzcart\|table\|cat_titles}}, {{vbzcart/query\|qryCat_Depts}}
	* '''Fields''':		* '''Fields''':
	** '''CatKey''' is used in the catalog-building process (Enter Title Groups) when searching within a supplier for a particular title		** '''CatKey''' is used in the catalog-building process (Enter Title Groups) when searching within a supplier for a particular title
	* '''History''':		* '''History''':
	** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query		** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query
			** '''2011-01-29''' Added "t.Desc AS Descr" to help with searching; t.Desc should eventually be renamed to t.Descr because "DESC" is an SQL keyword
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS
Line 10:		Line 11:
	t.ID,		t.ID,
	t.Name,		t.Name,
			t.Desc AS Descr,
	UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,		UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
	LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,		LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,

Woozle: changing CatKey_Title back to CatKey

2010-11-06T22:04:02Z

changing CatKey_Title back to CatKey

← Older revision		Revision as of 22:04, 6 November 2010
Line 2:		Line 2:
	* '''Requires''': [[../../tables/cat_titles\|cat_titles]], [[../qryCat_Depts\|qryCat_Depts]]		* '''Requires''': [[../../tables/cat_titles\|cat_titles]], [[../qryCat_Depts\|qryCat_Depts]]
	* '''Fields''':		* '''Fields''':
	** '''~~CatKey_Title~~''' is used in the catalog-building process (Enter Title Groups) when searching within a supplier for a particular title		** '''CatKey''' is used in the catalog-building process (Enter Title Groups) when searching within a supplier for a particular title
			* '''History''':
			** '''2010-11-06''' Changed '''CatKey_Title''' back to '''CatKey''' because "Title" should be the default context for this query
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS
Line 10:		Line 12:
	UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,		UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
	LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,		LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,
	t.CatKey ~~AS CatKey_Title~~,		t.CatKey,
	d.ID_Supplier,		d.ID_Supplier,
	t.ID_Dept,		t.ID_Dept,

Woozle: moved from single-page listing

2008-11-30T18:43:54Z

moved from single-page listing

New page

==Details==
* '''Requires''': [[../../tables/cat_titles|cat_titles]], [[../qryCat_Depts|qryCat_Depts]]
* '''Fields''':
** '''CatKey_Title''' is used in the catalog-building process (Enter Title Groups) when searching within a supplier for a particular title
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Titles AS
SELECT
t.ID,
t.Name,
UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,
t.CatKey AS CatKey_Title,
d.ID_Supplier,
t.ID_Dept,
t.DateAdded,
t.RstkMin AS QtyMin_Rstk,
t.Notes,
t.Supplier_CatNum AS Supp_CatNum
FROM cat_titles AS t LEFT JOIN qryCat_Depts AS d ON t.ID_Dept=d.ID;</mysql>
<section end=sql />