• Replies 5 replies
  • Subscribers 415 subscribers
  • Views 306 views
  • Users 0 members are here
Related

Easy way to explain "HAS" vs. "IN"

Jessica Bonanno
$organization

I am putting together a training document for List Manager and Extraction Manager.

Does anyone have an easy, lay-man terms way to explain (and maybe give examples) the difference between HAS and IN operators?

Thanks in advance.

Jessica

  • $organization

    I recently had it explained to me in a way that made it incredibly clear -- I'll see if I can translate my notes for you. 

    IN/NOT IN: Inclusive. Use "IN" when the two criteria options are both looking at the same back-end data table - criteria that must be evaluated together.

    HAS/DOES NOT HAVE. Each criteria is evaluated separately. Use for criteria that does not need to, or cannot, refer to the same data point. 

     

  • $organization

    Hi Jessica,

    In my training materials, I have used the same slides as Tatiana.  I also add this information:

    •All criteria from the same table are combined to look for a single entry (e.g. a single contribution or single ticket order) in the table that meets all of the criteria, except for those that use the HAS or DOES NOT HAVE operators.

    •IN requires that the criteria be in the same row of data. Using IN will often lead to fewer constituents being selected than using HAS. If the results are significantly smaller than expected, check to see if IN was used where HAS is appropriate.

    •Using NOT IN excludes constituents who have no entry in the table which the criterion is evaluating. For example, when using NOT IN with contribution criteria, constituents who have never made a contribution of any sort will be excluded.

    •Using DOES NOT HAVE includes constituents who have no entry in the table which the criterion is evaluating. For example, when using DOES NOT HAVE with contribution criteria, constituents who have never made a contribution of any sort will be included.
    Hope that is helpful.
    Susan

     

    •Using DOES NOT HAVE excludes constituents who have the selected value(s) regardless of any of the other criteria in the set.
  • $organization in reply to Tatiana Jofat

    Thank you for the responses. I am trying to make this make sense for front end users, who know just the basics of list manager and extraction manager. It seems to be one of those topics that is hard to get your head wrapped around.

  • $organization

    Hi Jessica,

    Below are the examples I’ve used in my documents. 

    Pictures really help.

     

    Tatiana

     

     

     

     

    Using the below screen shots as examples,

     

    The IN function will pull those that have values in all criteria lines simultaneously. 

     

     

     

     

    The HAS function will give those that match a value in one or the other of the criteria lines. 

     

     

     

     

    Tatiana Jofat

    Director, Tessitura Support

    P: 212.415.5481 | F:212.415.5788

    92nd St Y, 1395 Lexington Avenue, New York, NY 10128

    92Y.org  | Facebook | Twitter

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jessica Kalinski
    Sent: Tuesday, July 05, 2016 11:42 AM
    To: Tatiana Jofat
    Subject: [Tessitura Ticketing Forum] Easy way to explain "HAS" vs. "IN"

     

    I am putting together a training document for List Manager and Extraction Manager.

    Does anyone have an easy, lay-man terms way to explain (and maybe give examples) the difference between HAS and IN operators?

    Thanks in advance.

    Jessica




    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!

  • $organization

    Hello, 

    This is how I have summarised them in my training session:

    IN = They MUST have this!

    HAS = They can have this, but doesn’t necessarily need to link to anything else I want

    NOT IN = They can have this, but not if it links to the other thing I want

    DOES NOT HAVE = They definitely MUST NOT have this at ALL!

    Kelly