Single Find Searching

What Happens:

To find records, work in Find mode. You type criteria (the value or values to find) into fields in a find request, which looks like a blank record. When you perform a find, JimmyRig searches through all the records in a table, comparing the criteria you specify with the data in the table. Records with data matching the criteria become the found set, which is the subset of records being browsed. Records that don’t match are omitted. You can constrain (narrow) or extend (broaden) the found set. You can also save the found set, for example a farming area, so you can repeatedly come back to it. You can work with just the records in the found set. You can also open a new window in order to perform different find requests on the same data.

Steps:

1. Go to a layout that has fields you want to enter criteria in. You can change layouts and enter criteria on more than one layout.
2. Choose View menu > Find Mode or press the Enter Find Mode button.
3. In the find request, select a text, number, date, time, timestamp, or calculation field to use for finding, then type a value in the field.
4. Click Find in the status area, or choose Requests menu > Perform Find. You can do one or more of the following during or after performing a find request:

Narrow an existing found set

For example, after searching for all of the Duck properties, you can narrow the search to find all of sold listings:

1. In the Dare Database click Find mode, Select Carolina Dunes in the Subdivision field and hit your Enter key. JimmyRig displays the found set in Browse mode.
2. Switch back to Find mode (click the Find Mode button) and type the criteria to narrow the search (select Active in the Status field).
3. Choose Requests menu > Constrain Found Set. The found set now consists of all sold properties in Carolina Dunes.

Broaden an existing found set

For example, after searching for owners in Carolina Dunes, you can broaden the search to also find owners in Osprey:

1. In Find mode, perform a find to find customers in Carolina Dunes. JimmyRig displays the found set in Browse mode.
2. Switch back to Find mode (click the Find Mode button) and type the criteria to broaden the search (type Osprey in the Subdivision field).
3. Choose Requests menu > Extend Found Set.
   The found set now consists of owners of property in Carolina Dunes and Osprey.
   Note: To quickly extend the found set in Browse mode, use the shortcut menu. Click in the field (or select a partial value in the field), then right-click (Windows) or Control-click (Mac OS), and choose Extend Found Set.

Finding empty or non-empty fields
To find fields that are not empty (i.e., fields that have data)
Type: *

To find fields that are empty
Type: =

Finding duplicate values
Type: !

To show all records again just hit the Show All Records button

Tips:

• To find dates In June, 2005
  Type: 6/2005

• From July 1997 through October 1998
  Type: /1997...10/1998

• That occur on a Friday
  Type: =Friday
  

• From the 10th through the 16th of October or November, 2006 (if the date format is MM/DD/YYYY)
  Type: {10...11}/{10...16}/2006

• To avoid confusion when working with dates, always use four-digit years.

JimmyRig
©1997-2015