Search/Sort/Filter
Searching the database
What is Search?
Local Search
The Local Search' function helps you to locate the record(s) that contain the piece of data you are looking for. With this application, you are able to locate a piece of text in any field in the opened data file, with the capability of moving to the next record(s) filling your search criteria.
Online Search
The Online Search' function helps you to locate the record(s) or web pages that contain the piece of data you are looking for. With this application, you are able to locate a piece of text on the Internet or Intranet in:
- Databases that are on our Web dB Server;
- Online Search Engines;
Search / Local Search
How to use the Search function?
When in the Search' dialog:
- Select the field to be searched (notice the All fields' option!);
- Select the Start from' (beginning or end);
- Input the text to search for (note the previous entries);
- Press the Find' button to activate search.
Find Results Options
- With the Exact Phrase: the entire phrase (Text To Search For) must exist in one data field;
- With At Least 1 of the Words: at least 1 of the words (Text To Search For) must exist in one data field;
- With All of the Words: all of the words (Text To Search For) must exist in one data field but not necessarily in the same order;
- With None of the Words: none of the words (Text To Search For) must exist in one data field;
Radio-button and Check-box fields
You have to serach for a value of "0" to find unchecked Checkbox fields and for a value of "1" to find checked Checkbox fields. To search for Radiobutton fields use the item index such as 0, 1, 2, etc.
What is the Result of a Search?
The Search' function positions you in the first record that matches your search criteria. Use the Find next' button to go to next records that contain the text searched for.
What is the result of a search when the "Non-Stop Search Mode" option is marked ?
The program goes through entire database looking for records that match search criteria. When the search is finished ONLY those records are displayed that contain the text. In order to return to All-Records-Display set the Filter Scope option to All Records (in the Filter dialog box), or select All Records in The Filter Button Popup Menu.
Search / Online Search
How to use the Online Search function?
When in the Online Search' dialog:
To use Online Search function you have to be connected to the Internet (Intranet).
- Select the Search Engine.
- Input the text to search for.
- Press the 'Find' button to activate search.
What is the Result of a Search?
The Online Search' function displays the result web page(s) in your browser. Note: If you set Internal Web Browser option on in Options Window the result will be displayed in the Organizer's browser window.
Define a new Online Search
- Online Search, search a database on a Web dB Server
- Open Online Search window.
- Click on the Add/Edit button.
- Enter Search Name.
- Select Web dB Search in the Search Type section.
- Enter public user ID (case sensitive) for the database.
- Enter Database Name (case sensitive).
Additionally you have to define the Web dB Server address. Open the Web dB Server Login Settings window and enter Server Address (Web dB Server/Setup item on the main menu).
We provide all above parameters for public databases that are searchable on our server. (Example: Web Recipe Archive)
- Online Search, search an Internet or Intranet search engine
- Open Online Search window.
- Click on the Add/Edit button.
- Enter Search Name.
- Select Other Search Engines in the Search Type section.
Enter URL Link of the search engine in the following form: URL link followed by a question mark (?), then the name of the input edit box (this is the name of the edit box that accepts search strings in the search form), and the equal sign.
Example: Yahoo search URL Link: http://search.yahoo.com/bin/search?p=
Selecting a subset of all records - Filters
What is filtering?
Filtering is a method of limiting the number of records displayed to a certain range. A filter specifies the criteria for the process. A filtering example: list me all the records with the value of the Date' field greater than 01/01/1992' .
Kinds of filters.
A filter can specify a criterion for one or more fields in the record. The more criteria for the filter you specify, the better chance of obtaining the range of records that interest you.
How to access the Filter' function?
The Filter function can be located in the Filter option on the Advanced/Filter option on the Main Menu, and in the Speed Bar (advanced section), at the bottom of the screen. However, the fastest access to filter options is from the Sort Bar displayed at the top of the Table Of Contents above the Record Grid.
« |
