TaxonomyTerms

Create,Update,List and Delete the Taxonomy Terms for the WordPressOnline website.

Table Specific Information

SELECT

The add-in uses the WordPress API to process some of the filters.

Taxonomy supports the '=' comparison.
Slug supports the '=' comparison.

The add-in processes other filters client-side within the add-in. For example, the following queries are processed server side:

SELECT * FROM TaxonomyTerms WHERE Taxonomy='post_tag'
SELECT * FROM TaxonomyTerms WHERE Slug='tagTest'
SELECT * FROM TaxonomyTerms WHERE Taxonomy='post_tag';
SELECT * FROM TaxonomyTerms WHERE Taxonomy='post_tag' and Slug='tagTest';

INSERT

To insert a taxonomy term, the following column is required: Taxonomy.

INSERT INTO TaxonomyTerms (Slug, Name, Taxonomy) VALUES ('tagtest', 'Taxonomy term name', 'post_tag')

UPDATE

To update a taxonomy term you must specify the following columns: Taxonomy and Slug.

UPDATE TaxonomyTerms SET  Name= 'Modified taxonomy term name', Description = 'Modified taxonomy term description' WHERE Taxonomy='post_tag' AND Slug='tagTest'

DELETE

To delete a taxonomy term you must specify the following columns: Taxonomy and Slug.

DELETE FROM TaxonomyTerms WHERE Taxonomy='post_tag' AND Slug='tagTest'

Columns


Name	Type	ReadOnly	References	Description
Slug [KEY]	String	True		The URL-friendly identifier (slug) for the taxonomy term.
Taxonomy	String	False	TaxonomyPostType.Name	The taxonomy this term belongs to, such as category, post_tag, or a custom taxonomy.
Description	String	False		A brief explanation or summary describing the purpose or meaning of the term.
FeedUrl	String	False		The RSS feed URL associated with this taxonomy term.
ID	Int	True		The unique numeric identifier assigned to the taxonomy term.
Name	String	False		The display name of the taxonomy term as it appears in WordPress.
Parent	Int	False		The ID of the parent term if this term is part of a hierarchical taxonomy.
PostCount	Int	False		The total number of posts currently assigned to this taxonomy term.