could anyone provide how to edit codes to include multiple zip codes in a list manager (that also can be used in extractions?) And should I use = or Like?
Say someone has an inactive address at zip 10013 but current address is other zip, the constituent record still gets included in this SQL code.
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Matthew Hoyt Sent: Tuesday, May 12, 2015 5:53 PM To: Joe Hsu Subject: RE: [Tessitura Development Forum] Multiple zips in extractions
Hey Joe,
So glad you could get where you need to go (more or less)! What kind of invalid addresses are you getting?
Lucie, nice job explaining how to work the manual edit!
From: Joe Hsu <bounce-joehsu1335@tessituranetwork.com> Sent: 5/12/2015 9:17:07 PM
Your code definitely works! But I think it picked up invalid addresses as well – not a big deal for the the project I am doing for the time being.
THANK YOU SO MUCH for teaching me this.
I have to really sit down and learn SQL.
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Matthew Hoyt Sent: Tuesday, May 12, 2015 5:07 PM To: Joe Hsu Subject: Re: [Tessitura Development Forum] Multiple zips in extractions
Hi Joe,
Here's an example of how to get more than one zip code via a manual edit. Does this help?
select distinct customer_no from dbo.VS_ADDRESS where LEFT(postal_code,5) in ('63124','63116') and primary_ind = 'Y'
Matt
From: Joe Hsu <bounce-joehsu1335@tessituranetwork.com> Sent: 5/12/2015 4:40:31 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!