Shows the field values of a record.
Synopsis
- find_record [common options] [-t/ype record
type] [-field name] * [-f/ield field
name] * [^field name] * [-e/xclude field
name] * [+field name] [+f/ieldfield
name ] * [-all_fields/-af] [-sort_names/-sn] [-no
recname/-nr] [-no headers/-nh] [-no names/-nn]
[-no values/-nv] record_id | -r/ecord "type id"
| -dbid num | -input file
name
Description
Displays information about a record
including the current state, field values, and history. Information can be
viewed but not modified.
Options and arguments
- -t/ype record_type
- The type of record you are modifying. If no value is provided, the default
record type is used.
- -field name
- The names of the specific fields to display. If a field name is unique,
an unambiguous prefix of the name can be used. For example, you can enter
"head" for the headline field.
- -f/ield field name
- Alternate format for specifying the fields to display. Use this format
if the field is the same name as a subcommand option.
- +field name
- Forces a field to display even if it is excluded by other options.
- +f/ield field name
- Alternate format for specifying fields that must be displayed. Use this
format if the field is the same name as a subcommand option.
- -all_fields/-af
- Displays all fields containing a value.
- -sort_names/-sn
- Sorts the fields displayed in ascending, alphabetical order.
- -type_names/-tn
- Includes the field type of displayed records.
- -va/lue
- Displays field values only.
- -no_recname/-nr
- Excludes the record header line.
- -no_headers/-nh
- Excludes the descriptive headers between sections of information.
- -no_names/-nm
- Excludes field labels before the information displayed. Displays history
information and field values only.
- -no_values/-nv
- Excludes field values and history in the information displayed. Displays
field names only.
- record_id
- The ID of the record or records to find.
- -r/ecord "type id"
- The alternate format for specifying the record to find. Use this format
if multiple records are across different record types.
- -dbid num
- The internal database ID of the record to modify.
- -input file name
- The file that contains the record ID of the record. The record IDs must
be grouped by record type. Within each group, each record ID must be on a
separate line.
Examples
Display information about
a particular record. Selected fields are displayed.
CQTOOL> find_record SAMPL00000011 -Headline -Severity -Priority
RECORD: SAMPL00000011
value:4-Minor
req:READ_ONLY
type:STRING
name:Severity
value:3-Normal Queue
req:READ_ONLY
type:STRING
name:Priority
value:logout button should be disabled during sale
req:READ_ONLY
type:STRING
name:Headline
Display information about a particular record. Selected fields
which are abbreviated are displayed.
CQTOOL> find_record SAMPL00000011 -Head -Sev -Prior
RECORD: SAMPL00000011
value:4-Minor
req:READ_ONLY
type:STRING
name:Severity
value:3-Normal Queue
req:READ_ONLY
type:STRING
name:Priority
value:logout button should be disabled during sale
req:READ_ONLY
type:STRING
name:Headline
Display the details of the field headline for a record in a
terse format.
CQTOOL> find_record SAMPL00000011 -Headline -nh -nn
RECORD: SAMPL00000011
logout button should be disabled during sale
READ_ONLY
STRING
Display information about a particular record. Selected fields
are displayed in a sorted order.
CQTOOL> find_record SAMPL00000011 -Headline -Severity -Priority -sn
RECORD: SAMPL00000011
value:logout button should be disabled during sale
req:READ_ONLY
type:STRING
name:Headline
value:3-Normal Queue
req:READ_ONLY
type:STRING
name:Priority
value:4-Minor
req:READ_ONLY
type:STRING
name:Severity