Filter Contact History by Name: Exact Text | Vantage CX - Filter Contact History by Name: Exact Text - 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
Use the name of the Message, Channel (both Interactive and Delivery), Response, and Message Strategy to filter contact history. The name special keyword is used as a parameter in the contactHistory expression function. This distinguishes it from filtering by keyname, which is the default mechanism when the name parameter is omitted. Using name for a specific Contact History field is similar to running a SQL query as follows:
select * from contact_history_table where <field type>_name = '<name to search>'
Name is case-sensitive when used in expressions.

Example 1

Criteria:
-Qualify if: 
-Message M1 has been extended or responded to the customer
 
Expression:
set("extendedOrResponded", contactHistory("message", "name", "M1")) &&
count(extendedOrResponded) > 0

Example 2

Criteria:
-Qualify if: 
-A Message has been extended or responded in Channel 'SMS'
 
Expression:
set("extendedOrResponded", contactHistory("channel", "name", "SMS")) &&
count(extendedOrResponded) > 0

Example 3

Criteria:
-Qualify if: 
-A Message has been extended or responded to the customer
-For Message Strategy 'Recharge'
 
Expression:
set("extendedOrResponded", contactHistory("messageStrategy", "name", "Recharge")) &&
count(extendedOrResponded) > 0