You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get Data activity with SQL View for current program entry

Hi experts,

We have created a progam and use GetData to update Entry Tracking Variable. For Get Data Activity setting, we will choose SQL View as my screenshot:

Let say we will have Supplemental Table named Customer_Booking with custom field RESERVATION_ID, EMAIL_ADDRESS and system field CREATED_DATE_. The SQL View will count the total booking order of customer that match with EMAIL ADDRESS for both Profile List and Supplemental Table(Customer_Booking).

How can we access email address of program entry in SQL View so that we can query for current customer?

Something like: Select ProfileList.EMAIL_ADDRESS_ , Customer_Booking.EMAIL_ADDRESS FROM ProfileList P, Customer_Booking C WHERE P.EMAIL_ADDRESS_ = {EMAIL_ADDRESS_PROGRAM_ENTRY} AND P.EMAIL_ADDRESS_ = C.EMAIL_ADDRESS

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!