Triggered emails list question

For dates you should always use logical operator between in List Manager …

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Samantha Smith
Sent: Friday, December 14, 2012 8:05 AM
To: Sabina Spilkin
Subject: [Tessitura Next Generation Forum] Triggered emails list question

Hi guys,

I've recently started getting to grips with Triggered Emails and putting together the lists to run them. I want to create a list of every constituent that booked to a certain show 3 days ago, with the ticket purchase acting as the trigger.

So far, I've managed to successfully pull a list of everyone who booked within 3 days using the criteria;
Ticket Production IN Ticket Production Season
Ticket Order Date >= DayRunDate -3

However when I use the Ticket Order Date criteria with a different operator to get only constituents who booked 3 days ago;
TicketOrderDate = DayRunDate -3

the count returns 0 constituents.

I thought from reading the documentation and my previous experience with Extractions and List Builder that this criteria would have given me the data I need, especially as Tessitura won't let me select any other operators such as Like or Has that may give an exact date. From checking the original list using the operator >= there are customers who booked exactly 3 days ago, I can see that there is data there, it just doesn't appear when I use the operator =. Has anyone else had this problem?

Sam

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

For dates you should always use logical operator between in List Manager …

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Samantha Smith
Sent: Friday, December 14, 2012 8:05 AM
To: Sabina Spilkin
Subject: [Tessitura Next Generation Forum] Triggered emails list question

Hi guys,

I've recently started getting to grips with Triggered Emails and putting together the lists to run them. I want to create a list of every constituent that booked to a certain show 3 days ago, with the ticket purchase acting as the trigger.

So far, I've managed to successfully pull a list of everyone who booked within 3 days using the criteria;
Ticket Production IN Ticket Production Season
Ticket Order Date >= DayRunDate -3

However when I use the Ticket Order Date criteria with a different operator to get only constituents who booked 3 days ago;
TicketOrderDate = DayRunDate -3

the count returns 0 constituents.

I thought from reading the documentation and my previous experience with Extractions and List Builder that this criteria would have given me the data I need, especially as Tessitura won't let me select any other operators such as Like or Has that may give an exact date. From checking the original list using the operator >= there are customers who booked exactly 3 days ago, I can see that there is data there, it just doesn't appear when I use the operator =. Has anyone else had this problem?

Sam

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!