BizTalk Adapter for WordPress

Build 20.0.7587

Categories

Create, update, delete, and query Categories to use for categorizing your posts.

Table Specific Information

SELECT

The 本製品 uses the WordPress API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.

SELECT * FROM Categories WHERE Parent = 0
SELECT * FROM Categories Order By Id
SELECT * FROM Categories WHERE Id IN ('130', '129')
Also, ordering by Count, Description and Name, is handled by the WordPress API.

Insert

To insert a category the following column is required: Name.

INSERT INTO Categories (Description, Name, Parent) VALUES ('This is an example Category', 'myCategory', '138')

Update

To update a category you must specify the following column: Id.

UPDATE Categories SET Name='updatedName', Description='Updated description.', Parent=137 WHERE Id='139'

Delete

To delete a category you must specify the following column: Id.

DELETE FROM Categories WHERE Id = '139'

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Unique identifier for the term.

Count Integer True

Number of published posts for the term.

Description String False

HTML description of the term.

Link String True

URL of the term.

Name String False

HTML title for the term.

Taxonomy String True

Type attribution for the term.

Parent Integer False

The parent term ID.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587