find_record

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

Feedback