Searching Dialog: Output Commands: Display, Type, Print, Report
Dialog Output Functions (Commands)
Functions / Commands Usage Examples, Notes
sort set/<records> /<fields>
- You can sort by multiple fields.
- The sort is ascending, unless you add a d at the end.
- sort s28/all/au,ti
- A screen-by-screen display
- d[set #]/[format]/ [item #s]
- A continuous display of results
- Geneates a tabular display of the fields that you select.
- Offers varied ways to deliver or print selected search results.
- Use pr cancel to cancel a print command.
Searching Dialog: Command & Web Output Formats
Standard Output Formula
Standard Output Formats
Example Custom Output Formats
DialogWeb Equivalent Formats
Dialog: Sorting Search Results
Improving Search Results by Eliminating Duplicates
How to Elimate Duplicate Records
Using id and rd operators
Command Operator USAGE identify duplicates id id s11 - Creates a set of records with all duplicate ones grouped together. remove duplicates rd rd s3 - Removes duplicates in set 3
NOTE: Generally, you will just be using this operator, as this reduces the number of results that you may need to display.
NOTE: Only sets created by rd can be used in subsequent select (s) commands.
Using the not operator
If s1 is larger than s2, then create the following combination search:
Searching Dialog: Search Results: Using Search Save & Execute
- Stores strategy permanently until deleted. Serial numbers begin with S.
SAVE TEMP <name>
- Stores strategy for seven days; automatically deleted.
- Serial number begins with T.
- Stores strategy and PRINT command(s) until deleted.
- PRINT command required.
- Automatically executes strategy against each new update to database in which entered.
- Serial number begins with D.
To use Saved Searches
- Type b <databases or onesearch categories>, which will indicate where you want to execute the save search.
- Then use the Execute or Execute Steps command (see below) to start a new search using the saved search.
- execute steps <snnnn>
- execute <tnnnnn>
- execute steps <name of search>
- Creates a Search*Save of data extracted for field xx of MAPxx TEMP records already retrieved.
- If STEPS is used, data is formatted into separate search statements in Search*Save.
Recall is useful for reviewing the serial numbers and/or names of the saved searches that you stored under your password. The displayed list shows the serial number or name, the date and time saved, and the number of command lines in the search.
- Recalls Search*Save nnnnn, displaying all set-producing commands and comment lines, without executing the search.
- Displays serial numbers of all permanent SAVEs, date entered, and number of lines.
- Displays serial numbers of all temporary SAVEs, date entered, and number of lines.
- Displays serial numbers of all SDIs, dates entered, databases in which stored, and number of lines.
- Executes entire strategy. Only last line is assigned a EX nnnnn set number.
EXECUTE STEPS nnnnn
- Executes entire strategy. Assigns set number to each EXS nnnnn search element. Preferred form.
- Executes strategy nnnnn form command line x to command line y only. STEPS may also be used: EXS nnnnn/x-y
EXECUTE nnnnn/USER a
- Executes strategy nnnnn originally entered by user a (a=user number).
- STEPS may also be used
Example: EXS nnnnn/USER a
EXECUTE nnnnn/x-y/USER a
- Executes strategy nnnnn from command line x to command line y, originally entered by user a.
- STEPS may also be used
Example: EXS nnnnn/x-y/USER a
- Deletes search nnnnn from system.
OTHER SEARCH*SAVE OPTIONS
- A three to five alphanumerical name may be specified following the SAVE, SAVE TEMP, and SAVE SDI commands.
- Example: SAVE TEMP SOLAR
Adding Comments to a Search *Save
- An informative comment may be stored in a SEARCH*SAVE by entering an asterisk in place of a command, followed by up to 240 characters of "comment."
- The line will be saved with any SEARCH*SAVE command, and will display in RECALL of the search.
- Example: * Search for R.J.Flappjack