You can create a more complex search string to filter for multiple criteria. When creating multiple strings you will use "AND" or "OR" to combine different single strings. (AND and OR are called operands). The use of the AND and the OR operand will affect the way the filter acts:

1. Using the "AND" operand limits the search by requiring that all values must be present. For example: an Artwork filter "Medium = Giclee" AND "Size = 10 x 8" will locate only artworks that meet both criteria: Giclee AND size 10 x 8.

2. Using the "OR" operand limits the search by requiring that only one of the values is present. For example: an Artwork filter "Medium = Giclee" OR "Size = 10 x 8" will locate all artworks that are Giclee (irrespective of size) and all artworks that are 10 x 8 (irrespective of medium). The "OR" filter will select more artworks than the "AND" filter.

Modifying the Filter by using Different Comparisons.

In the above example, Artwork filter "Medium = Giclee" AND "Size = 10 x 8", we only use the "=" comparison. However, there are other comparisons that can be used. The choice of the Comparison used will determine what is filtered:

1. Use "=" when the records selected by the filter will each be equal to the value specified in the Where combo-box.
For example, you are creating an advanced filter to select patrons with a MailCity of San Francisco.
For example, you are creating an advanced filter to select artwork in the Series "Pioneer Valley 2005".

2. Use "< >" when the records selected by the filter will each be values lesser than or greater than the value specified in the Where combo-box. (All values except the value specified in the Where combo-box).
For example, you are creating an advanced filter to select all patrons except those with a MailCity that is Olympia.
For example, you are creating an advanced filter to select all Proofs except MainEdition.

3. Use ">" when the records selected by the filter will each be greater than the value specified in the Where combo-box.
For example, you are creating an advanced filter to select all patrons with Average Purchases of more than $500. That is to say, $500.01 or more.
For example, you are creating an advanced filter to select all artworks Created after 2002. That is to say, 2003 or later.

4. Use ">=" when the records selected by the filter will each be greater than or equal to the value specified in the Where combo-box.
For example, you are creating an advanced filter to select all patrons who have Total Purchases of $800 or more.
For example, you are creating an advanced filter to select all artwork with a Retail Price of $750 or more.

5. Use "<" when the records selected by the filter will each be less than the value specified in the Where combo-box.
For example, you are creating an advanced filter to select all patrons who have Total Purchases of less than $500. That is to say, $499.99 or less.
For example, you are creating an advanced filter to select all artwork Created before 1995. That is to say, 1994 or earlier.

6. Use "<=" when the records selected by the filter will each be less than or equal to the value specified in the Where combo-box.
For example, you are creating an advanced filter to select all patrons who were Entered on or before January 3rd, 2001. That is to say, an EntryDate less than or equal to 01/03/2001.
For example, you are creating an advanced filter to select all artwork of Size 10 x 8 or less.

7. Use "Like" when the records selected by the filter have a value specified in the Field combo-box which relates to a value in the Like box.
For example, you are creating an advanced filter to select all patrons with a PatronName beginning with "A".
For example, you You are creating an advanced filter to select all artworks with a Title beginning with "A".

8. Use "Is Null" when the records selected by the filter do not have a value specified in the Where combo-box.
For example, you are creating an advanced filter to select all patrons who do not have an email address.
For example, you are creating an advanced filter to select all artworks that are not in any Series.

9. Use "Is Not Null" when the records selected by the filter have a value specified in the Where combo-box.
For example, you are creating an advanced filter to select all patrons who have an Email Address.
For example, you are creating an advanced filter to select all artworks that are in any Series.

Using Parentheses to Create a Filter.

Depending on whether you are combining different single criteria filters with "AND" or with "OR", you may need to use parentheses to determine how the elements are calculated:

1. When using only "AND" to combine different single criteria filters it is not necessary to use parentheses.

2. When using "OR" to combine different single criteria filters it is necessary to use parentheses to show how the elements are combined.

3. When combining "And" and "OR" operands, you may need parentheses around "AND" groups of items.

Once you have created and saved an advanced filter, you can reuse it in different places:
An advanced patron filter can be created or accessed in Patrons or Mail List.
An advanced artwork filter can be created or accessed in Artwork, Consignment, Registry, Project, Media, Price List, Show Entry and Mail List.

Creating and accessing advanced patron filters.

Advanced patron filters can be created or accessed in Patron and Mail List functions. Here are some examples:

To create an advanced patron filter in View Patrons:
1. From the Main Switchboard, click on Patrons.
2. In View Patrons, click on Adv Filter.
(An advanced patron filter can be similarly created in Patron List and Patron Data Sheet.)

To access an already created filter, use the Filter combo box.

To create an advanced patron filter when creating a new Mail List:
1. From the Main Switchboard, click on Mail List.
2. Click on New, create and save a new Mail List.
3. In Edit Mail List, click on Add Patrons and select "Add individual patrons from select list".
4. In the "Add Patrons to Mail List" screen, click on Adv Filter

To access an already created filter, use the Filter combo box.

Creating and accessing advanced artwork filters.

Advanced artwork filters can be created or accessed in Artwork, Consignment, Registry, Project, Media, Price List, Show Entry and Mail List (select image) functions. Here are some examples:

To create an advanced artwork filter in View Artwork:
1. From the Main Switchboard, click on Artwork.
2. In View Artwork, click on Filter to display the Filter screen.
3. In the Filter screen, click on Create Advanced Filter

To access an already created filter, use the Filter combo box.

To create an advanced artwork filter in Artwork List or Artwork Datasheet:
1. From the Main Switchboard, click on Artwork.
2. In View Artwork, click on Artwork List to display the Artwork List.
3. In Artwork List, click on Adv Filter.
(For Artwork Datasheet, select Artwork Datasheet instead of Artwork List)

To access an already created filter, use the Filter combo box.

To create an advanced artwork filter when creating a new Consignment:
1. From the Main Switchboard, click on Consignments.
2. Click on New, create and save a new Consignment.
3. In Edit Consignment, click on Select Work to display the "Send Work to Consignment" screen.
4. In the "Send Work to Consignment" screen, click on Adv Filter.

To access an already created filter, use the Filter combo box.

To create an advanced artwork filter when creating a new Media:
1. From the Main Switchboard, click on Media.
2. Click on New Media, create and save a new Media.
3. In Media Edit, click on Add Images to display the "Select Images for Media" screen.
4. In the "Select Images for Media" screen, click on Adv Filter.

To access an already created filter, use the Filter combo box.

Select an advanced artwork filter in View Artwork and use the result in an Artwork Report:
1. From the Main Switchboard, click on Artwork to display View Artwork.
2. In View Artwork, use the Filter combo box to select a previously created advanced filter.
-- Only artwork that meet the criteria of the filter will display.
3. In View Artwork, click on Reports to display Artwork Reports.
4. In Which Report, select the appropriate report.
5. In Filter Report, choose From Artwork Form Filter.
6. After selecting any appropriate options, click Preview.
The report generated will only relate to the filtered artworks.
The same can be achieved when first creating an advanced filter.
The same can be achieved in Artwork List or Artwork Datasheet.

To create an advanced artwork filter in Artwork Reports:
1. From the Main Switchboard, click on Artwork.
2. In View Artwork, click on Reports to display Artwork Reports.
3. In Which Report, select the appropriate report.
4. In Filter Report, choose Select from List.
5. Click Preview to display Artwork List.
6. In Artwork List, click on Adv Filter.

To access an already created filter, use the Filter combo box.