FilterDefinition

Defines an audience based on specified rules in a filter. This table does not support inserts.

Table-Specific Information

Select

The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.

For example, the following (but not only) query is processed server side:

SELECT * FROM FilterDefinition WHERE CreatedDate > '2017/01/25'

Update

You must specify the ObjectId in the WHERE clause when executing an update against this table.

UPDATE FilterDefinition SET Name = 'Changed' WHERE ObjectId = 'nzxcaslkjd-123'

Delete

You must specify the ObjectId in the WHERE clause when executing a delete against this table.

DELETE FROM FilterDefinition WHERE Object = 'nzxcaslkjd-123'

Columns


Name	Type	ReadOnly	Description
ObjectID [KEY]	String	False	System-controlled, text string identifier for object.
Client_ID	Int	True	The Id of the client.
Client_ClientPartnerKey	Int	True	User-defined partner key for an account.
Name	String	False	Name of the object or property.
CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
CreatedDate	Datetime	False	Indicated the date and time of the object's creation.
ModifiedDate	Datetime	False	Indicates the last time object information was modified.
Description	String	False	Describes and provides information regarding the object.
DataSource_ID	Int	True	Read-only identifier for an object.
DataSource_ObjectID	String	True	System-controlled, read-only text string identifier for object.
DataSource_Name	Int	True	Name of the object or property.
DataSource_ListName	Int	True	The list name of the data source.
DataSource_CustomerKey	String	True	User-supplied unique identifier for an object within an object type.
DataSource_CreatedDate	Datetime	True	Read-only date and time of the object's creation.
DataSource_ModifiedDate	Datetime	True	Indicates the last time object information was modified.
DataFilter	String	False	Filter parts for a filter definition.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.

Build 24.0.9060