Table get terms to filter

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 get_term_name 4.2 get_term_name 4.3 get_term_table 4.4 get_term_name_field 5 Default Entries

Database Version

1.3.6

Description

A collection of terms used to provide various types of data-filtering for searches and index listings. It ties in with the various pulldown menus in sideboxes, the primary one being manufacturers_id, which runs specific filters on data shown tied to a selected manufacturer_id.

Table Details

Primary Key

get_term_name

Indexed Fields

None.

Columns

get_term_name

The term to allow filtering on.

Type:	varchar(255)
Null:	No
Default:

get_term_name

The term to allow filtering on.

Type:	varchar(255)
Null:	No
Default:

get_term_table

The table to which the described filtering term applies.

Type:	varchar(64)
Null:	No
Default:

get_term_name_field

The field of the specified table to which filtering should be enabled

Type:	varchar(64)
Null:	No
Default:

Default Entries

get_term_name: | manufacturers_id | TABLE_MANUFACTURERS | manufacturers_name

get_term_name: | music_genre_id | TABLE_MUSIC_GENRE | music_genre_name

get_term_name: | record_company_id | TABLE_RECORD_COMPANY | record_company_name