ContentCategoryMemberships
Gets details of a record that maps content to a content category.
Select
The component 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 component.
- Id supports the '=, IN, >=, <=, >, <' operators.
- CreatedAt supports the '=, >=, <=, >, <' operators.
- UpdatedAt supports the '=, >=, <=, >, <' operators.
For example, the following queries are processed server-side:
SELECT * FROM ContentCategoryMemberships WHERE Id = 1 SELECT * FROM ContentCategoryMemberships WHERE Id IN (1, 2) SELECT * FROM ContentCategoryMemberships WHERE Id >= 1 SELECT * FROM ContentCategoryMemberships WHERE Id < 2 SELECT * FROM ContentCategoryMemberships WHERE Id <= 2 SELECT * FROM ContentCategoryMemberships WHERE Id >= 1 AND Id <= 10 SELECT * FROM ContentCategoryMemberships WHERE CreatedAt <= '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-27 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE CreatedAt >= '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE CreatedAt = '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE CreatedAt < '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE CreatedAt > '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt <= '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt >= '2022-01-25 01:02:02.0 ' AND UpdatedAt <= '2022-02-27 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt >= '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt = '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt < '2022-02-25 01:02:02.0' SELECT * FROM ContentCategoryMemberships WHERE UpdatedAt > '2022-02-25 01:02:02.0'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of content category memberships. |
| CreatedAt | Datetime | The date and time the content category membership was created. |
| UpdatedAt | Datetime | The date and time the content category membership was last updated. |
| ContentCategoryId | Integer | The content category Id. |
| CreatorId | Integer | The Id of the creator. |
| CreatorType | String | The type of the creator. |
| Type | String | The type of the content category membership. |