VbzCart/queries/qryCat Titles

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 18:53, 29 January 2011 by Woozle (talk | contribs) (t.Search, duh)
Jump to navigation Jump to search

Details

  1. REDIRECT Template:l/vc/query
  • Fields:
    • 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
    • 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

<mysql>CREATE OR REPLACE VIEW qryCat_Titles AS 

 SELECT
   t.ID,
   t.Name,
   t.Desc AS Descr,
   t.Search,
   UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
   LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb,
   t.CatKey,
   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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCat_Titles&oldid=14922"