TaxonomyTerms
List all terms of the taxonomies.
Table Specific Information
SELECT
The server uses the WordPress API to process some of the filters. The server processes other filters client-side within the server. Note: Taxonomy is required to fetch TaxonomyTerms. Use the slug values from the taxonomies view to retrieve the taxonomy column value.
For example, the following queries are processed server side.
SELECT * FROM TaxonomyTerms WHERE Taxonomy = 'books';
SELECT * FROM WordPress.TaxonomyTerms WHERE taxonomy IN ('post_tag','Category');
Columns
| Name | Type | References | Description |
| id | Integer | The unique identifier of the taxonomy term within the specified taxonomy. | |
| Count | Integer | The number of posts or items associated with this taxonomy term. | |
| Link | String | The URL link associated with the taxonomy term, used for navigating to the term's archive or details page. | |
| Name | String | The display name of the taxonomy term, shown in the WordPress admin and on the front-end site. | |
| Slug | String | The URL-friendly identifier for the taxonomy term, used in permalinks and in API requests. | |
| Taxonomy | String | The taxonomy to which this term belongs, such as category, post_tag, or a custom taxonomy. | |
| Parent | Integer | The unique identifier of a parent term in a hierarchy is given, where a value of 0 indicates that there is no parent. | |
| Description | String | A textual description of the taxonomy term, explaining its purpose or providing additional context. |