ContentCategoryOwnerships

A record that maps content to a content category.

Select

The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.
ContentCategoryId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ContentCategoryOwnerships WHERE Id = 1

SELECT * FROM ContentCategoryOwnerships WHERE Id IN (1,2)

SELECT * FROM ContentCategoryOwnerships WHERE Id >= 1

SELECT * FROM ContentCategoryOwnerships WHERE Id < 2

SELECT * FROM ContentCategoryOwnerships WHERE Id <= 2

SELECT * FROM ContentCategoryOwnerships WHERE Id >= 1 AND Id <= 10

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-27 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt <'2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE CreatedAt >'2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt <='2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt >= '2022-01-25 01:02:02.0 ' AND UpdatedAt <= '2022-02-27 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE UpdatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategoryOwnerships WHERE ContentCategoryId = 1

Columns

Name	Type	Description
Id [KEY]	Integer	Id of content category ownerships.
CreatedAt	Datetime	The date and time the content category ownership was created.
UpdatedAt	Datetime	The date and time the content category ownership was last updated.
ContentCategoryId	Integer	The content category Id.
CreatorId	Integer	Creator Id.
CreatorType	String	Creator type.
Type	String	Type.

TDV Adapter for Outreach

ContentCategoryOwnerships

Select

Columns