Advanced Queries - Quick Guide

Super Search Window

• Unlike the quick search, you cannot type into the search bar. 
• Select the module to search at the left, i.e. objects, exhibitions, or constituents 
• To run a saved query, click the dropdown arrow in the search bar and select Query to load it,
  • Click the search glass to run your search
• To create a new custom query
  • Click the gears to open the query designer
  • Use the Query designer (see step by step guide below)
  • Click the search glass to run your search

Quick Steps

1. Click on the gears to open the query designer window
2. Select a field group
3. Click + to add a search line from a field group
4. Select a Field Name to search
5. Select the Relation operator (equals, contains, is more than, is less than, etc)
6. Enter the term you are looking for in the Field Value
7. Continue adding lines as necessary, use and/or to expand or limit your results 
   1. AND must meet all conditions (painting AND Art of the United States)
   2. OR allows multiple values in results (painting OR sculpture)
8. Use Show Record Count to preview your results (if you get 0 records or way too many, check your work and revise)
9. Click OK to submit your search, once you return to the Super Search Window you will see "ad hoc query" with a time stamp. Click the search glass to open the list of records you have searched for.

Hints

• to delete a search line tick the box at the left, then click the trash can icon
  • you can only select and delete one line at a time
• to search for a phrase or full name use double quotes to enclose, i.e. "Joan Mitchell" or "Stacked Waters"
• Change your View Results As options at the left to start open a list or the data entry view for your first record