Difference between revisions of "Make a Field Conditionally Required"
(→Step 1. Create the script) |
|||
| Line 4: | Line 4: | ||
== Step 1. Create the script == | == Step 1. Create the script == | ||
| − | The script is created as a .spl file and placed in the site/mods/majic directory. | + | The script is created as a .spl file and placed in the site/mods/majic directory. |
| − | + | ||
| − | + | ||
| + | <!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->cr::zmyscript(...) {<br>string zmsg; <br>//Enter your if statement<br>if(assignee.userid != cst.userid) {<br>//Enter your alert message that appears if the if statement is met<br>zmsg=format(" Assignee must be the same as the logged in user in order to close %s", ref_num); <br>set_error(1); <br>set_return_data(zmsg); <br>return; <br>} <br>}<!--c2--></div><!--ec2--> | ||
== Step 2. Create the trigger == | == Step 2. Create the trigger == | ||
Revision as of 03:01, 13 January 2008
This article provides instructions for making a field conditionally required.
In the steps that follow, the example code is used to ensure the Assignee is the only only able to close a ticket. Other examples are displayed at the bottom of this article.
Contents
Step 1. Create the script
The script is created as a .spl file and placed in the site/mods/majic directory.
string zmsg;
//Enter your if statement
if(assignee.userid != cst.userid) {
//Enter your alert message that appears if the if statement is met
zmsg=format(" Assignee must be the same as the logged in user in order to close %s", ref_num);
set_error(1);
set_return_data(zmsg);
return;
}
}
Step 2. Create the trigger
This step is to create the trigger that will initiate the script. The methods used to implement the script vary based on the Service Desk release.
r11.x triggers are created via the Schema Designer utility. Simply add a Site-Defined Trigger to the desired table.
pre-r11.x triggers are made by creating a .mod file and placing it in the site/mods/majic directory.
Step 3. Publish the Schema changes
r11.x 1. Save your Schema changes 2. Stop the Service Desk service 3. Run pdm_publish from a command line 4. Start the Service Desk service
pre-r11.x Recycle the Service Desk service
Note: This logic can be used to greatly expand system functionality by ensuring that data gets collected when any number of conditions exist.
Tips
String statements together using && Example (is_null(anyfield1) && is_null(anyfield2))
For not null add an ! Example (!is_null(anyfield))
