Filter Contact History Attributes: TIME Attributes | Vantage CX - Filter on Contact History Attributes: TIME Attributes - Vantage Customer Experience

Vantage Customer Experience User Guide
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Vantage Customer Experience
Release Number
1.6
Published
October 2023
Language
English (United States)
Last Update
2023-10-26
dita:mapPath
hbt1563223944614.ditamap
dita:ditavalPath
oyf1565965838286.ditaval
dita:id
tmo1562969305444
Product Category
Teradata Applications

Example 1

Criteria:
-Qualify if: 
-Message 'M1' has been extended 4 times
-In 'SMS' Channel
-For Message Strategy 'Recharge'
-In the last 7 days
-AND 'Text receipt time' is between 1pm and 5pm
 
Expression:
set("extendedCH", contactHistory("response", "extended", "message", "msg1", "messageStrategy", "recharge")) &&
set("extendedOnChannel", contactHistory(extendedCH, "frequency", equalTo(4), "recency", "day", lessThanOrEqual(7))) &&
set("textreceipttimes", contactHistory(extendedOnChannel, "attribute", 
                  "ContactHistory.sms.dcat.textreceipttime", formatTimePeriod("hour"), between(13,17))) && 
count(textreceipttimes) > 0

Example 2

Criteria:
-Qualify if: 
-Message 'M1' has been extended 4 times
-In 'SMS' Channel
-For Message Strategy 'Recharge'
-In the last 7 days
-AND 'Text receipt time' is after 5pm
 
Expression:
set("extendedCH", contactHistory("response", "extended", "message", "msg1", "messageStrategy", "recharge")) &&
set("extendedOnChannel", contactHistory(extendedCH, "frequency", equalTo(4), "recency", "day", lessThanOrEqual(7))) &&
set("textreceipttimes", contactHistory(extendedOnChannel, "attribute", 
                  "ContactHistory.sms.dcat.textreceipttime", formatTimePeriod("hour"), greaterThanOrEqual(17))) && 
count(textreceipttimes) > 0