View source for Set Request/Incident/Problem Status on Dispatch Change

__NOTOC__
[[Category:Change Orders]]
[[Category:Customizations]]
[[Category:Incidents]]
[[Category:r6]]
[[Category:r11]]
[[Category:Problems]]
[[Category:Requests]]
[[Category:Schema Changes]]
{{Global Header}}
{{Global Announcement}}

== Overview ==
This article provides instructions for setting the Status of a Request, Incident, or Problem when initiating a '''Dispatch Change''' Activity.

== Procedures ==
=== Step 1. Create the script ===
{{Create Spell Script}}

<source lang="javascript">alg::zsetstat(...) {
    string z_stat;

    // Put the code of the desired status below
    z_stat = "CODE";

    send_wait(0, this, "call_attr", "call_req_id.status", "set_val", z_stat, "SURE_SET");
    if (msg_error()) {
        logf(ERROR, "error setting status to %s on %s %s - %s", z_stat, call_req_id.type.sym, call_req_id.ref_num, msg[0]);
    } else {
        logf(SIGNIFICANT, "successfully set status to %s on %s %s", z_stat, call_req_id.type.sym, call_req_id.ref_num);
    }
}</source>

=== Step 2. Create the trigger ===
This step is to create the trigger that will initiate the script. The methods used to implement the trigger vary based on the Service Desk release. 

''For r11.x releases'' triggers are created via the [[Schema Designer]] utility. Simply add the following code as a [[Site-Defined Trigger]] to the '''[[Act Log Table|alg (Activity Log)]]''' table.
 POST_VALIDATE zsetstat() 113 FILTER(type == 'CHG');

''For older releases'' triggers are made by creating a [[.mod file]] and placing it in the [[$NX_ROOT]]/site/mods/majic directory. Name the [[.mod file|.mod]] anything you like, but it is recommended that it be preceded with a 'z'.

<source lang="javascript">OBJECT alg {
  TRIGGERS {
    POST_VALIDATE zsetstat() 113 FILTER(type == 'CHG');
  };
};</source>

=== Step 3. Publish the Schema changes ===
{{Publish Schema Change}}