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

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

92^nd 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!

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

92^nd 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!