• Replies 3 replies
  • Subscribers 414 subscribers
  • Views 68 views
  • Users 0 members are here
Related

List Inclusion/Exclusion

Cathy-Anne Cook
$organization

Hi;

I'm looking for a way to take 3 lists and only keep the people that are in all 3 lists.

Like a ven diagram anyone who doesn't fall into all 3 lists I don't want to see.

I tried just pulling a list that used all of this criteria in it but it was unable to pull anyone as I was re-using very specific criteria sets though when I to into the accounts I can see that they should be pulling hundreds of constituents.

I am pulling on Performance Date and Performance Title so with this am able to get constituents that are going to 2 of the shows but once I re-use one of those criteria the list generate no-one.

 

Please help.

  • $organization

    Hi Cathy-Anne,

    Have you tried taking a fourth list and adding separate criterions of each list with an operator of HAS?

    So your set would look like this

    List    HAS    [list 1]
    List    HAS    [list 2]
    List    HAS    [list 3] 

     



    [edited by: Ryan Rowell at 1:45 PM (GMT -6) on 1 Nov 2013]
  • Former Member
    Former Member $organization

    Hi Cathy-Anne,

    I'm not sure I understand exactly what you're trying to do, but if you have 3 separate lists X, Y, and Z that are all working as you expect you should be able to set up a fourth list with criteria like these to combine them:

    List IN X
    List HAS Y
    List HAS Z 

    That would return only the constituents who are on all 3 lists.

    When you re-use criteria in the same list the difference between "in" and "has" is really key. If you're using "Performance Title IN ..." more than once you'll get zero results. But, you could try using "Performance Title IN A" with  "Performance Title HAS B" and "Performance Title HAS C" for example.

    Does that make sense?

  • $organization

    Thank you!

     

    From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Matthew Echert
    Sent: November-01-13 2:01 PM
    To: Cathy-Anne Cook
    Subject: Re: [Tessitura Customer Service Forum] List Inclusion/Exclusion

     

    Hi Cathy-Anne,

    I'm not sure I understand exactly what you're trying to do, but if you have 3 separate lists X, Y, and Z that are all working as you expect you should be able to set up a fourth list with criteria like these to combine them:

    List IN X
    List HAS Y
    List HAS Z 

    That would return only the constituents who are on all 3 lists.

    When you re-use criteria in the same list the difference between "in" and "has" is really key. If you're using "Performance Title IN ..." more than once you'll get zero results. But, you could try using "Performance Title IN A" with  "Performance Title HAS B" and "Performance Title HAS C" for example.

    Does that make sense?

    From: Cathy-Anne Cook <bounce-cathyannecook1561@tessituranetwork.com>
    Sent: 11/1/2013 12:45:02 PM

    Hi;

    I'm looking for a way to take 3 lists and only keep the people that are in all 3 lists.

    Like a ven diagram anyone who doesn't fall into all 3 lists I don't want to see.

    I tried just pulling a list that used all of this criteria in it but it was unable to pull anyone as I was re-using very specific criteria sets though when I to into the accounts I can see that they should be pulling hundreds of constituents.

    I am pulling on Performance Date and Performance Title so with this am able to get constituents that are going to 2 of the shows but once I re-use one of those criteria the list generate no-one.

     

    Please help.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Customer Service Forum. You may reply to this message to post to the Customer Service 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!