ContentCategoryOwnerships
A record that maps content to a content category.
Select
The connector will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports the '=,IN,>=,<=,>,<' operators.
- CreatedAt supports the '=,>=,<=,>,<' operators.
- UpdatedAt supports the '=,>=,<=,>,<' operators.
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'
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. |