Conducting a Search

Select SEARCH>{Required Record Type}. The relevant Search screen is displayed
Select the field you want to search from the list of searchable fields displayed in the Where: pop-up list
Select a comparison operator from the middle pop-up list (default for text searches is ‘Like’)
Enter search criteria in the data entry text box
Where the field searched is associated with a controlled list of terms or authority file you can optionally click on Thesaurus icon to open the relevant authority file and drag and drop terms from the thesaurus into the data entry field on the Search screen
Check the Case Sensitive box if required
Select a Boolean Operator and repeat steps (2) - (4) to enter further search criteria
The system displays search strategy in Structured Query Language (SQL) in the grey SQL window at the bottom of the search screen

Tips:

You can manually edit the text displayed in the grey SQL window to further refine your search. For example, after entering the following search, you could delete the left truncation symbol ‘%’.

The edited search will now retrieve records that include western, westerns, western-based in the Title but not retrieve records with southwestern in the Title.

You can also manually edit the text displayed in the grey SQL window to nest more complicated Boolean searches by including additional parenthesis. For example, in the search below, all the Title elements and all the GMD elements are enclosed in additional parenthesis.

Select the field you want to sort the search results by from the Sort Order pop-up list
Click SEARCH or press the [Enter] key
The Search Results Screen displays a summary list of results sorted by the sort field selected
Double click on an item to display the full record

Tip:

Click Find Again icon on the Toolbar to return to the previous search screen and refine a search further. The previous search string is displayed in the SQL window at the bottom of the Search screen.