===========================
Searching Dialog: Output Commands: Display, Type, Print, Report
Scope
Dialog Output Functions (Commands)
Functions / Commands Usage Examples, Notes sort records
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
display records
d s3/9/all
d s8/2/19
d 1/6/2-9
- A screen-by-screen display
- d[set #]/[format]/ [item #s]
type
t s2/4/1-31
- A continuous display of results
report
report s8/2/co,py,sa
- Geneates a tabular display of the fields that you select.
pr s1/2/3
pr s3/5/3-9/ti
- Offers varied ways to deliver or print selected search results.
- Use pr cancel to cancel a print command.
Searching Dialog: Command & Web Output Formats
Scope
Standard Output Formula
Standard Output Formats
Example Custom Output Formats
d
s1/6,su/1-5 d
3/ti,au,ab,kwic/1-5
DialogWeb Equivalent Formats
Dialog: Sorting Search Results
Scope
Command
Usage
Format sort
set/records/fields
Searching
Dialog:
Improving Search Results by Eliminating
Duplicates
Scope
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 3NOTE: 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
Scope: Search*Save
Command: Save
SAVE
- Stores strategy permanently until deleted. Serial numbers begin with S.
SAVE TEMP
SAVE TEMP <name>
- Stores strategy for seven days; automatically deleted.
- Serial number begins with T.
SAVE SDI
- 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.
- Examples
- execute steps <snnnn>
- execute <tnnnnn>
- execute steps <name of search>
Command: MAPxx
MAPxx
- Creates a Search*Save of data extracted for field xx of MAPxx TEMP records already retrieved.
MAPxx STEPS
- If STEPS is used, data is formatted into separate search statements in Search*Save.
Command: Recall
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.
RECALL nnnnn
- Recalls Search*Save nnnnn, displaying all set-producing commands and comment lines, without executing the search.
RECALL SAVE
- Displays serial numbers of all permanent SAVEs, date entered, and number of lines.
RECALL TEMP
- Displays serial numbers of all temporary SAVEs, date entered, and number of lines.
RECALL SDI
- Displays serial numbers of all SDIs, dates entered, databases in which stored, and number of lines.
Command: Execute
EXECUTING SEARCH*SAVES EXECUTE nnnnn
- 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.
EXECUTE nnnnn/x-y
- 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 aEXECUTE 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
Deleting Search*Saves
RELEASE nnnnn
- Deletes search nnnnn from system.
OTHER SEARCH*SAVE OPTIONS NAMING
- 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