Most searches are based on specific fields, but there are also about a dozen criteria that apply to entire records. (Keep in mind that these criteria can be used in any combination with other search criteria.)
Is Already Selected — This option allows new selections to be partially based on the results of previous selections. If this option is chosen, only records that were already matched in a previous selection will be identified as a match. In the example below, a previous selection located all organizations with Photo in the name. Now that selection is being revised to include only photo related organizations in Texas. (To learn about another way to revise an existing selection see Refining a Selection.)
Is Not Already Selected — This option allows new selections to be partially based on the results of previous selections. If this option is chosen, only records that were not matched in the previous selection will be identified as a match in this selection.
Is a Data Record — Any raw data record (not a summary record) will be identified as a match.
Is a Summary Record — Any summary record will be identified as a match. (This option duplicates the Select Summaries command that was available in previous versions of Panorama.)
First NN records — This option allows you to select the first few records in the database. In this example the first 25 records in the database will be selected.
Last NN records — This option allows you to select the last few records in the database.
Every other record (1, 3, 5…) — This option allows you to select half of the records in the database. Every other record is selected, starting with the first record.
Every other record (2, 4, 6…) — This option allows you to select half of the records in the database. Every other record is selected, starting with the second record.
Every 3rd record (1, 4, 7…) — This option allows you to select one third of the records in the database. Every third record is selected, starting with the first record.
Every 3rd record (2, 5, 8…) — This option allows you to select one third of the records in the database. Every third record is selected, starting with the second record.
Every 3rd record (3, 6, 9…) — This option allows you to select one third of the records in the database. Every third record is selected, starting with the third record.
See Also
- checkemptyselection -- notifies the user if a selection failed, and reverts to the previous selection.
- Date Search Options -- searching dates within a database.
- Favorite Searches -- saving and recalling favorite searches.
- find -- locates the first visible record in the active database for which the specified condition is true.
- Find & Replace Dialog -- finding and replacing a word or phrase (with an option to use a regular expression).
- Find/Select Dialog -- using a dialog to search for specific data.
- findabove -- locates the next previous record (above the current record) in the active database for which the specified condition is true.
- findbackwards -- locates the last visible record in the active database for which the specified condition is true.
- findbelow -- locates the next visible record (below the current record) in the active database for which the specified condition is true.
- findid -- locates a record in the active database by its ID number (see info("serverrecordid").
- findnth -- finds the nth (2nd, 3rd, 4th, etc.) record that matches a true-false test.
- findselect -- opens the standard *Find/Select* dialog.
- findselectdialog -- opens the standard *Find/Select* dialog.
- Formula Search -- searching with a formula.
- Handling Empty Selections in Code -- dealing with an empty selection data set.
- ifselect -- combines the select and if info("empty") operations into a single statement.
- info("empty") -- returns true or false depending on the result of the last select operation. If no records were selected the function will return true, otherwise it will return false.
- info("found") -- returns true or false depending on whether the last *find* or *next* statement was successful.
- info("selectduplicatesortwarning") -- works with the selectduplicatesnowarning statement to ascertain whether or not the database was sorted correctly when last search for duplicates was performed.
- nextmatch -- locates the next visible record in the active database for which the condition specified in the most recent Find statement is true.
- Numeric Search Options -- searching numbers within a database.
- pleaseselectall -- makes sure that all records are selected.
- previousmatch -- locates the previous (closer to the top) visible record in the active database for which the condition specified in the most recent Find statement is true.
- Refining a Selection -- selecting a subset or superset of a previous selection."
- removeselected -- deletes all selected records from the database.
- removeunselected -- deletes all unselected records from the database.
- safeselect -- makes visible only those records for the active database for which the specified condition is true. If no records match, the previous selection is retained.
- safeselectwithin -- makes visible only those previously selected records in the active database for which the specified condition is true. If no records match, the previous selection is retained.
- search( -- searches through an item of text looking for a character, word or phrase. If it finds an exact match (including upper/lower case) with the character, word or phrase, it returns its position within the text item. If it does not find the character, word or phrase, it returns zero.
- searchanycase( -- searches through an item of text looking for a character, word or phrase. If it finds a match (upper/lower case may be different) with the character, word or phrase, it returns its position within the text item. If it does not find the character, word or phrase, it returns zero.
- Searching -- searching a database to find or select information.
- select -- makes visible only those records for the active database for which the specified condition is true.
- Select Duplicates Dialog -- opens the standard *Select Duplicates* dialog sheet.
- selectadditional -- adds unselected records to a previously selected group if they match the true-false test.
- selectall -- makes every record in the database visible.
- selectduplicates -- selects records containing duplicate information in the database.
- selectduplicatesnowarning -- selects records containing duplicate information in the database.
- Selecting with the Context Menu -- searching for information related to the current cell.
- selectreverse -- makes every visible record invisible, and every invisible record visible.
- selectwithin -- uses a Boolean formula to exclude records from a previously selected group.
- Text Search Options -- searching text within a database.
History
| Version | Status | Notes |
| 10.0 | No Change | Carried over from Panorama 6.0 |