BizTalk Adapter for WordPress

Build 20.0.7587

Tags

Create, update, delete, and query Tags to associate with your posts.

Table Specific Information

Select

The 本製品 uses the WordPress API to process supported 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 Tags WHERE Id Not IN ('8','9')
SELECT * FROM Tags WHERE Id = 5
SELECT * FROM Tags Order By Id
Also, ordering by Count, Description, and Name is handled by the WordPress API.

Insert

To insert a tag you must specify the following column: Name.

INSERT INTO Tags (Name, Description) VALUES ('MyTag', 'A tag')

Update

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

UPDATE Tags SET Name='Updated name', Description='Updated description' WHERE Id='12345'

Delete

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

DELETE FROM Tags WHERE Id = '12345'

Columns

Name Type ReadOnly Description
Id [KEY] Integer False

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.

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