Output Set element for a constituents next performance date

A few things. You are looking at ticket history. Chances are that the next performance is not even in the history table. Secondly, if this is for Mail2 why not create a view that mail2 can pull directly from? If you would like to see and example view let me know .

 

Travis

From: Mason Wright <bounce-masonwright3210@tessituranetwork.com>
Sent: 6/22/2016 12:36:05 PM

I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

 

Description: Next Performance Name

Data Select: !.perf_name

Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

Data Where: (blank)

single row is checked

 

Description:Next Performance Date

Data Select: !.perf_dt

Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

Data Where: (blank)

single row is checked

 

When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

A few things. You are looking at ticket history. Chances are that the next performance is not even in the history table. Secondly, if this is for Mail2 why not create a view that mail2 can pull directly from? If you would like to see and example view let me know .

 

Travis

From: Mason Wright <bounce-masonwright3210@tessituranetwork.com>
Sent: 6/22/2016 12:36:05 PM

I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

 

Description: Next Performance Name

Data Select: !.perf_name

Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

Data Where: (blank)

single row is checked

 

Description:Next Performance Date

Data Select: !.perf_dt

Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

Data Where: (blank)

single row is checked

 

When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!