Change Attributes Filter
Fields available in Data Current Table:
DataId (uniqueidentifier)
BatchId (uniqueidentifier)
AutoNumber (int)
IntegrationId (nvarchar(256))
Title (nvarchar(256))
Summary (nvarchar(512))
IsEnabled (bit)
CreateDate (datetime)
ModifyDate (datetime)
StartDate (datetime)
EndDate (datetime)
Fields available in Attributes:
will display after you select your module
Filter Examples:
Data Current Table:
cpsys_DataCurrent.Title = 'Record Title'
cpsys_DataCurrent.AutoNumber = 1
cpsys_DataCurrent.DataId= 'Record Guid'
cpsys_DataCurrent.IsEnabled = 1
cpsys_DataCurrent.AutoNumber BETWEEN 1 AND 1000
Between Dates:
DATEADD(dd, 0, DATEDIFF(dd, 0,cpsys_DataCurrent.StartDate)) >= '09/22/2009' AND DATEADD(dd, 0, DATEDIFF(dd, 0,cpsys_DataCurrent.EndDate)) <= '10/22/2009'
Less or Equal then Now:
cpsys_DataCurrent.StartDate <= GETDATE ()
Greater or Equal then Now:
cpsys_DataCurrent.StartDate >= GETDATE ()
Data Current Attributes:
cpsys_DataCurrent.Attributes.value('(/cpCollection/group/property[@id="Taxonomy"]/value)[1]', 'NVARCHAR(MAX)') LIKE '%Taxonomy Guid%'
cpsys_DataCurrent.Attributes.value('(/cpCollection/group/property[@id="Audiences"]/value)[1]', 'NVARCHAR(MAX)') LIKE '%Taxonomy Guid%'
* cpsys_DataCurrent.Attributes.value('(/cpCollection/group/property[@id="Attributes_Name"]/value)[1]', 'NVARCHAR(256)') = ''
* This will retrieve all records where specified attribute is empty.