Advanced-Searches

Performing Advanced Searches

Advanced searching is an incredibly powerful feature for those that need finer control over how they work with their database. With Advanced Search you have full access to the most relevant fields in the database, and the ability to apply more advanced filtering logic on those fields.

To access Advanced Search, choose one of the following:

• Advanced Search from the Tools menu
• Ctrl+Alt+A shortcut key
• the Advanced Search icon from the menu bar
• choosing Advanced Search from the search field drop-down listbox (bottom option) on the toolbar

Here's what the Advanced Search form looks like:

How to perform an advanced search

1. select a field you want to search on from the field listbox
2. choose the operation you want to perform (containing, not containing, = , like, not like, IS NULL, or IS NOT NULL)
3. supply the text you want to search on
4. click on the OK button

That's it. Your search results will appear in the movie list. That's the simplest form of an Advanced Search.

For more advanced searches you can combine more than one operation. To do so, click on the Add Condition button. A second search condition will be added to the form. Repeat the steps above. By default, the two operations will be ANDed together. Click on the AND text to toggle between AND and OR.

Here's what AND and OR mean --

AND: when terms are combined with the AND operator, retrieved records must contain all terms.
OR: when terms are combined with the OR operator, retrieved records may contain one or more of the search terms.

For even more advanced searches, you can combine multiple statements by grouping them in blocks. To do so, click on the Add block button. This will start a new block for search criteria. Again, by default, an AND operator will be used. Click on the AND word to toggle between AND and OR.

To delete a search criteria line, choose the Delete button.

Clicking on the Clear button will reset the form so that you can start over.

---