ContactMarketingRosters
The information about the contact lists used in audiences in Oracle Service Cloud Outreach Cloud Service.
Table-Specific Information
SELECT
The add-in will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the add-in.
SELECT * FROM ContactMarketingRosters WHERE id = 12 SELECT * FROM ContactMarketingRosters WHERE id > 15 SELECT * FROM ContactMarketingRosters WHERE lookUpName LIKE '%test' SELECT * FROM ContactMarketingRosters WHERE id IN (12, 23, 123) SELECT * FROM ContactMarketingRosters WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the isProofList and name columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO ContactMarketingRosters (isProofList, name) VALUES ('true', 'Incident extract limit')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE ContactMarketingRosters SET Comment = 'Incident extract limit' WHERE Name = 'Analytics Lab Attendees'
DELETE
Following is an example of how to Delete a record in this table.
For example:
DELETE FROM ContactMarketingRosters WHERE Name = 'Analytics Lab Attendees'
Columns
Name | Type | ReadOnly | Description |
Comment | String | False |
The description associated with the contact marketing roster. |
CreatedByAccountId | Long | True |
Id of createdByAccount. The staff account who created the list. |
CreatedByAccountlookUpName | String | True |
LookUpName of createdByAccount. The staff account who created the list. |
CreatedTime | Datetime | True |
The date and time when the contact marketing roster was created. This attribute is read-only. |
Id [KEY] | Long | True |
The unique identifier of the contact marketing roster. |
InterfaceId | Long | True |
Id of interface. The interface the list is associated with. |
InterfacelookUpName | String | True |
LookUpName of interface. The interface the list is associated with. |
IsProofList | Bool | False |
Indicates whether the contact marketing roster is a proof list. |
LookupName | String | True |
The name used to look up the contact marketing roster. |
Name | String | False |
The name of the contact marketing roster. |
PurgeData | Bool | False |
Indicates whether the contact marketing roster should be cleared periodically. The default value is false. |
UpdatedByAccountId | Long | True |
Id of updatedByAccount. The staff account who last updated the list. |
UpdatedByAccountlookUpName | String | True |
LookUpName of updatedByAccount. The staff account who last updated the list. |
UpdatedTime | Datetime | True |
The date and time when the contact marketing roster was last updated. This attribute is read-only. |
LastCountStatisticslastCount | Int | True |
The number of contacts in the contact marketing roster when the count was last calculated. |
LastCountStatisticslastCountedTime | Datetime | True |
The date and time when the contact marketing roster was last counted. |