Hi there,
We are trying to tap into some potential and I've been asked to pull a list of anyone in our database who has an address with a certain zip code. I've set up the extraction and have had success EXCEPT for it also includes names of people who have an INACTIVE address with that zip code. Why on earth would the extraction include people with these inactive addresses and is it possible to change this?!
Thanks!
Jillian,
The “Address Information” folder has “Address Active Status”. Use the operator “In” and the value “Yes” to get current, active addresses only.
Melanye
MELANYE TAYLOR
Database Manager
Advancement
THE MUSIC CENTER
135 N. Grand Avenue
Los Angeles, CA 90012
P: (213) 972-3123
F: (213) 972-4301
musiccenter.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jillian Pruitt Sent: Thursday, April 30, 2015 12:41 PM To: Taylor, Melanye Subject: Re: [Tessitura Development Forum] Extraction Pulls Constituents with Inactive Address
Within extraction manager, under the "Address Information" elements folder, there isn't an option for Inactive Addresses, so I'm unable to even enter that element. Is this a custom element?
From: Michele Keutsch <bounce-michelekeutsch5100@tessituranetwork.com> Sent: 4/30/2015 3:03:59 PM
You would also need to pull in the criteria "Inactive Addresses in No' to only pull active addresses.
Michele
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!