• Replies 13 replies
  • Subscribers 411 subscribers
  • Views 199 views
  • Users 0 members are here
Related

Lists: Multiple Zip Codes

Former Member
Former Member $organization

Is there any combination of Operators and wildcards that would allow for a simple list to select constituents from multiple zip codes?  I know an extraction can do this with one zip per keycode, but it would be great to be able to just do it in a list.

Thanks,  Adam

Parents
  • $organization
    My pleasure. Glad to help.

    --Tom

    On Mon, Oct 5, 2015 at 3:06 PM, Tessitura Development Forum wrote:

    Tom -- Thank you! Your instructions just saved me a lot of time. Margaret


    From: Tom Brown
    Sent: 9/26/2011 6:47:19 PM

    I came up with much the same.

    Created new Search Object in Tessitrua.

    T_Keyword

    Description: Postal_Code USA Zip (5 Digits)
    Data Type: String
    Edit Mask: None
    Detail TBL: VS_address
    Detail Col: left(!.postal_code,5)
    Ref Tbl: TR_CITYSTATE
    Ref Idcol: zip5
    Ref Desccol: zip5+ ' ' + city+', '+state
    Ref Where: country = 1
    Categrory: Address Information
    Use For List: List Only
    Multiple Value: [Not Checked]
    Control Group: [Blank]
    Custom Id: [Blank]
    Custom Limit: [Blank]
    Custom Required: [Not Checked]
    Custom Default Value: [Blank]
    Inc In Basic Search: [Not Checked]
    Keyword: Description: US Zip Codes the first 5 characters of the postal code on an address where country = USA

    We are also thinking of adding a first 3 char of US Postal Codes varient.







    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!
Reply
  • $organization
    My pleasure. Glad to help.

    --Tom

    On Mon, Oct 5, 2015 at 3:06 PM, Tessitura Development Forum wrote:

    Tom -- Thank you! Your instructions just saved me a lot of time. Margaret


    From: Tom Brown
    Sent: 9/26/2011 6:47:19 PM

    I came up with much the same.

    Created new Search Object in Tessitrua.

    T_Keyword

    Description: Postal_Code USA Zip (5 Digits)
    Data Type: String
    Edit Mask: None
    Detail TBL: VS_address
    Detail Col: left(!.postal_code,5)
    Ref Tbl: TR_CITYSTATE
    Ref Idcol: zip5
    Ref Desccol: zip5+ ' ' + city+', '+state
    Ref Where: country = 1
    Categrory: Address Information
    Use For List: List Only
    Multiple Value: [Not Checked]
    Control Group: [Blank]
    Custom Id: [Blank]
    Custom Limit: [Blank]
    Custom Required: [Not Checked]
    Custom Default Value: [Blank]
    Inc In Basic Search: [Not Checked]
    Keyword: Description: US Zip Codes the first 5 characters of the postal code on an address where country = USA

    We are also thinking of adding a first 3 char of US Postal Codes varient.







    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!
Children
No Data