Building a List

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

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

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 'Portland%') as e ON e.customer_no = a.customer_no

 Where  IsNull(a.inactive, 1) = 1