Search Dialog

Search Dialog

Summary

The search dialog is displayed as a popup. Use this dialog box to filter the result set from either a Simple Form or Tabbed Form.

For example, from the Employee Information screen, you could select Search to filter the result set down to employee records meeting certain criteria (e.g., all employees with the last name "Smith"). The sample screen shot shows you the Search dialog that would appear.

The dialog is different depending on which application is being searched. The number of fields and which fields are searched can be different for each screen. You can customize the background color.

Criteria

This group box contains two types of fields you can use to narrow your search: Text and Drop-Down Box.

Text

In a text field, you can enter part of the text for which you are searching. For example, Employee ID (in the sample screen shot) is a text field and, therefore, you can enter all or part of the ID for your search. If you enter part of the field, the search function will attempt to find all records that begin with the entered value. You can also enter a "%" at the beginning of search data. In this case, the search function will attempt to find all records that contain the entered value. Please note the field is optional. If you enter no value, the field will not be involved in the search criteria. 

Drop-Down Box

Certain fields are limited to fixed values.  Use a drop-down box (such as Module Access in the sample screen shot) to pick the value you want. The drop-down boxes are required, so an "ALL" option is provided.  If you select "All," the field will not be involved in the search criteria.

Sort By

Use the Sort By drop-down box to choose the ordering of the search results.

Execute

Use the Execute button to perform the search based on the supplied criteria. The results will be displayed in the table grid.

Select All

Use the Select All button to select all rows from the search.  Once selected, the button becomes Deselect All.  To select particular rows, select the button to the left of the row to highlight it.

OK

Use the OK button to import the selected rows into the application where the search was started.

Cancel

Use the Cancel button to return to the application where the search was started.

More

Use the More button to display more records if the number of records found exceeds the number of rows that can be displayed in a search. You can set the maximum number of rows in the Max Search Rows field in the General Options tab of the General Configuration screen.