Finding data

In Servoy, you find data using forms - either specially designed "search" forms or by using the same form that is used for data entry.

You enter your search criteria in Find mode.

To go to Find mode:

• Make sure you are in Data (ready) mode.
• Choose Select > Find.

You can perform a find (find data):

• In a single Find request.
• Within a set of found records (find in find).

In a single Find request, you might wish to:

• combine multiple requests (OR and AND).
• search for text, numbers, dates, times.
• search for ranges.
• search for duplicated data.
• search through related data.

To perform a find in a single find request:

• Choose Select > Find. OR
• Press the keyboard shortcut CTRL-F / CMD-F.
• Type in your find request.
• Press Enter or F3 to execute the request.

To perform a find in the current found set:

• Choose Select > Find or press CTRL-F / CMD-F.
• Type in your find request.
• Then choose Select > Reduce search to perform a find in find OR

Choose Select > Extend search to extend your request.

The overall speed of performing a search depends on a number of
variable factors:

• The type of database you use.
• The capacity and load of your database server.
• The capacity and load of your network.
• The type of searches you perform.