Super Search Queries - Quick Guide

Owned by Shelby Lakins
Last updated: Oct 05, 2023
3 min read

The Super Search or "Field-Specific Search" is the complex query designer to search multiple fields and conditions. Super Searches can be saved for frequent searches and to populate your personal dashboard with lists or projects you are working on. The open the Super Search window, click on the search glass next to your user menu.



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 
  • Click the gears to open the query designer
  • Click the search glass to run your search
  • Use Load Query to open and search a saved query


Anatomy of the Query Designer

There are two ways to add search condition lines in the query designer: Field Group and Relationships Diagram.

  • Field groups are customized to accommodate typical searches for staff.
  • The Relationship diagram requires advanced understanding of the relational database and it's data tables that hold specific information and the relationships between the tables. 



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
  • to search for a phrase use double quotes to enclose, i.e. "Joan Mitchell" or "Stacked Waters"
  • Change your View Results As options at the left to start with a list or the data entry view for your first record





Confluence Documentation | Web Privacy Policy | Web Accessibility