Hey all,
Looking for a little advice on the best way to pull a list (for an extraction) of accounts within several cities. We have Address Information > City as a List function. I've tried using this, put in City = xxx and then under or City = xxy. Unfortunately after that I can't add any more after that. Any suggestions?
Thanks,
Maurice
I don’t know how many cities you have, but I have created lists for individual cities and then combined them to one list.
Or perhaps an extraction with each segment being a different city.
I have done the same for zip codes, too.
Michelle
Michelle Wohlers Tessitura Operations Manager
2013/2014 SEASON International Season:
Pagliacci, Elixir of Love, Verdi Requiem, A Masked Ball, Don Quixote
San Diego Opera 1200 Third Avenue, Suite 1800
San Diego, CA 92101
Phone: (619) 232-7636
Fax: (619) 231-6915
www.sdopera.com
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Maurice Nounou Sent: Friday, April 11, 2014 11:36 AM To: Michelle Wohlers Subject: [Tessitura Ticketing Forum] Building a List
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Hi Maurice,
If it makes sense for your extraction, you could make a separate segment for each city. But, this might be a good case for configuring the Geographic Area criteria element. See this documentation: http://www.tessituranetwork.com/Help_System/Content/Criteria%20Sets/Working%20With%20Geographic%20Area.htm
-Michael Wilcox, Tessitura Network
Couple extra options for you.
I haven't played with this since v10, but at my old organization I built a custom view that pulled distinct zips out for use in a list manager dropdown. I would think you could do something similar with city to add a new list criteria with a dropdown option for you. For this you would check with your IT department most likely.
If you don't have too many cities, you could Manual Edit the list criteria code (if you have that access) to include some extra ones. There's a limit to how much code you can stuff in there, but you can probably get half a dozen or so extra cities.To do this, add your first city in the top field, second in the bottom, and click the manual edit button. You'll see something like what I've posted below. Copy everything from the word UNION (including union) and below from what you see in your system, paste on the end of the code, update that last city name to a third city, rinse and repeat until you have all the cities, or you run out of space.
EDIT* After you are done with the code, you just close and save the list. If you switch back to Graphical Edit it will undo what you've edited.
List manager example code (v12)
Select Distinct a.customer_no
From V_CUSTOMER_WITH_PRIMARY_GROUP a WITH (NOLOCK)
JOIN (Select a1.customer_no From vs_address a1 WITH (NOLOCK) Where a1.city like 'Seattle%') as e ON e.customer_no = a.customer_no
Where IsNull(a.inactive, 1) = 1
UNION
JOIN (Select a1.customer_no From vs_address a1 WITH (NOLOCK) Where a1.city like 'Portland%') as e ON e.customer_no = a.customer_no