• Replies 5 replies
  • Subscribers 415 subscribers
  • Views 308 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

Parents
  • $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.
Reply
  • $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.
Children
No Data