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)`

Service Management2017.11

Administer > Database administration > Data persistence > Database dictionary > Database dictionary data types > Create the unique and attribute subtables

Create the unique and attribute subtables

Applies to User Roles:

System Administrator

You must use the Windows client whenever you need to add or edit a new field/key in a database dictionary table.

To create the unique and attribute subtables:

Name the unique and attribute files.
1. Search for the dbdict from which you want to create subtables. In this example, the device dbdict is used.
2. Scroll down the Type column to locate an array of structures.
  Note: An array of structures is identified by an Array field type with a field of the same name.
3. Type Structure directly below the Array field. The Structure field name is indented. In this example, the array of structures is features.
4. Locate the features field of Type Structure.
5. Insert your cursor in the Type column for the features structure field.
6. Click Edit Field/Key.
7. In the field.window dialog box, type a name for the attribute file. The standard naming convention for the attribute file is: dbdict + array + attr. In this example, the attribute file is named devicefeaturesattr.
  Note: No spaces or special characters are allowed in the subtable names.
8. In the field.window dialog box, type a name for the unique file. The standard naming convention for the unique file is: dbdict + array + uniq. In this example, the unique file is named devicefeaturesuniq.
  Note: If the attribute file field is left blank, only the unique subtable will be created.
9. Click OK.
Designate unique fields in the array of structure.
1. Locate the field you want to designate as unique. In this example, the unique field is feature.id.
2. Insert your cursor in the Type column for the field you want to designate as unique.
3. Click Edit Field/Key.
4. Click the Unique in Structured Array check box.
5. Click OK.
6. Repeat steps a – e for each field you want to designate as unique.
From the database dictionary, click OK.

ITSMA Service Management updates the dbdict and creates the unique and attribute subtables from the array of structures.

Send Help Center feedback