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 Manager9.51

Administer > Database administration > System Definition > Forms, triggers, and links > Triggers > Create a Trigger record

Create a Trigger record

Applies to User Roles:

System Administrator

Triggers monitor files for certain activity types, such as Adds, Deletes, or Updates, and launches a specified RAD application when the appropriate conditions are met.

To create a trigger record:

From the System Navigator, click System Definition > Tables > triggers.
From the Keys sections, click New.
From the General section, select the trigger type from the More Actions menu.
Click Add.

From the Fields section, modify the properties of the available fields to define the trigger. You can use the table below as a general guideline for the most commonly-used parameters.

Property	Description
trigger.name	Any unique, meaningful name.
table.name	Select the file to be monitored by this trigger.
trigger.type	Select the specific activity to react to: 1 - Before Add - When adding a new record to this file, launch the application prior to committing the addition. 2 - After Add - When adding a new record to this file, launch the application after committing the addition. 3 - Before Update - When modifying a record in this file, launch the application prior to committing the change. 4 - After Update - When modifying a record in this file, launch the application after committing the change. 5 - Before Delete - When deleting a record in this file, launch the application prior to performing the deletion. 6 - After Delete - When deleting a record in this file, launch the application after performing the deletion. Note: Only triggers of type 4 (After Update), and type 6 (After Delete) are supported by Cascade Updates.
application.name	The RAD application to launch. Note: The RAD application may not require parameters and will only have access to $L.old, the record prior to the change, and $L.new, the post-change record. Note: For most Cascade Updates, set to cascade.update.wrapper. The only exception is if the file you are monitoring is the device file or a related device attribute file, such as joincomputer. In those cases, set to am.cascade.update.wrapper.

Send Help Center feedback