Add a key as the first key

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Applies to User Roles:

System Administrator

Example: Add the language.key field as a No Nulls key to the unitofmeasure database dictionary record.

In this example, you add the language.key field to the unitofmeasure record and assign it as the first key with a property of No Nulls. This field is a required field in the record.

To add a key as the first key:

From the System Navigator, click System Definition > Tables > unitofmeasure > Keys.

In the Keys section, click New.

In the General section, click the Type field. For this example, select No nulls in the Type list as the key type.

The following key types are valid:

Nulls and duplicates – allows nulls and duplicates in all the fields in the key.
No nulls – allows duplicates, if selecting No nulls, the key must contain data in at least one of the fields in the key.
No duplicates – allows null records but not duplicates. Although the data must be unique, but the field may be left blank.
Unique – must contain unique data and cannot be left blank.
IR key – files that contain an IR key must also contain another key that is Unique, with No nulls, No duplicates or Nulls, and Duplicates. A Service Manager file can contain only one IR key.

Click Add.

From the Choose a field to add to the key dialog, select the language.key field, and then click OK.

In the Keys section, select the key you added (language.key in this example), and click Up.

The key language.key now appears as the first key in the list of keys in the database dictionary record. All other keys are moved down the screen.

Once you are finished adding keys to the table, click Save and then click OK to confirm your changes.

Service Manager automatically updates and regen the file.

To remove the key, do the following: