Propagate Status to Children - Revision history

Gityerfix at 16:19, 7 December 2008

2008-12-07T16:19:40Z

Gityerfix: Needed to replace ORs with ANDs in the search logic

2008-11-05T14:55:49Z

Needed to replace ORs with ANDs in the search logic

Gityerfix: /* Step 1. Create the script */

2008-11-02T17:12:47Z

‎Step 1. Create the script

Gityerfix: /* Step 2. Create the trigger */

2008-11-02T17:11:41Z

‎Step 2. Create the trigger

Gityerfix: /* Step 1. Create the script */

2008-11-02T17:10:53Z

‎Step 1. Create the script

Gityerfix: /* Step 2. Create the trigger */

2008-11-02T17:10:30Z

‎Step 2. Create the trigger

Gityerfix: /* Step 3. Add field to Object Engine */

2008-10-27T20:15:06Z

‎Step 3. Add field to Object Engine

Gityerfix: /* See Also */

2008-10-27T20:12:32Z

‎See Also

Gityerfix: /* See Also */

2008-10-27T20:12:20Z

‎See Also

Gityerfix at 12:34, 31 August 2008

2008-08-31T12:34:07Z

@@ Line 101: / Line 101: @@
 == See Also ==
 [[Propagate Solution to Children]]<br>
-[[Set Request, Incident and Problem Status from Change Order]]
+[[Set Request/Incident/Problem Status from Change Order]]

@@ Line 38: / Line 38: @@
 	p_statsym = call_req_id.status.sym;
 	p_type = call_req_id.type.sym;
-	wc = format("parent = '%s' AND (status != '%s' OR status != 'RE' OR status != 'CL')", call_req_id, p_stat);
+	wc = format("parent = '%s' AND status != '%s' AND status != 'RE' AND status != 'CL'", call_req_id, p_stat);
 	send_wait(0, top_object(), "call_attr", "cr", "current_user_id");

@@ Line 29: / Line 29: @@
 <source lang="javascript">alg::zstat_to_child(...) {
-	if (zset_child_f == 1) {
+	string c_desc, c_num, c_origstatsym, c_type, p_num, p_stat, p_statsym, p_type, wc;
-		string c_desc, c_num, c_origstatsym, c_type, p_num, p_stat, p_statsym, p_type, wc;
+	object c_dob, c_list, group_leader;
-		object c_dob, c_list, group_leader;
+	int c_count, i;
-		int c_count, i;
+	uuid login_userid;
-		uuid login_userid;
-		p_num = call_req_id.ref_num;
+	p_num = call_req_id.ref_num;
-		p_stat = call_req_id.status;
+	p_stat = call_req_id.status;
-		p_statsym = call_req_id.status.sym;
+	p_statsym = call_req_id.status.sym;
-		p_type = call_req_id.type.sym;
+	p_type = call_req_id.type.sym;
-		wc = format("parent = '%s' AND (status != '%s' OR status != 'RE' OR status != 'CL')", call_req_id, p_stat);
+	wc = format("parent = '%s' AND (status != '%s' OR status != 'RE' OR status != 'CL')", call_req_id, p_stat);
-		send_wait(0, top_object(), "call_attr", "cr", "current_user_id");
+	send_wait(0, top_object(), "call_attr", "cr", "current_user_id");
-		login_userid = msg[0];
+	login_userid = msg[0];
-		send_wait(0, top_object(), "call_attr", "cr", "sync_fetch", "MLIST_STATIC", wc, -1,0);
+	send_wait(0, top_object(), "call_attr", "cr", "sync_fetch", "MLIST_STATIC", wc, -1,0);
-		c_count = msg[1];
+	c_count = msg[1];
-		c_list = msg[0];
+	c_list = msg[0];
-		if (c_count > 0) {
+	if (c_count > 0) {
-			for(i=0;i< c_count;i++) {
+		for(i=0;i< c_count;i++) {
-				send_wait(0, c_list, "dob_by_index", "DEFAULT", i, i);
+			send_wait(0, c_list, "dob_by_index", "DEFAULT", i, i);
-				c_dob = msg[0];
+			c_dob = msg[0];
-				send_wait(0, c_dob, "get_attr_vals",3,"ref_num","type.sym","status.sym");
+			send_wait(0, c_dob, "get_attr_vals",3,"ref_num","type.sym","status.sym");
-				c_num = msg[3];
+			c_num = msg[3];
-				c_type = msg[6];
+			c_type = msg[6];
-				c_origstatsym = msg[9];
+			c_origstatsym = msg[9];
-				if (description == action_desc) {
+			if (description == action_desc) {
-					c_desc = "Status changed from \'" + c_origstatsym + "\' to \'" + p_statsym + "\'" ;
+				c_desc = "Status changed from \'" + c_origstatsym + "\' to \'" + p_statsym + "\'" ;
-				} else {
+			} else {
-					c_desc = description;
+				c_desc = description;
-−
+			}
-				c_desc = c_desc + " (initiated from Parent " + p_type + " " + p_num + ")" ;
+			c_desc = c_desc + " (initiated from Parent " + p_type + " " + p_num + ")" ;
-				send_wait(0, top_object(), "get_co_group");
+			send_wait(0, top_object(), "get_co_group");
-				group_leader = msg[0];
+			group_leader = msg[0];
-				send_wait(0, c_dob, "change_status", group_leader, login_userid, c_desc, p_stat, NULL);
+			send_wait(0, c_dob, "change_status", group_leader, login_userid, c_desc, p_stat, NULL);
-				send_wait(0, group_leader, 'checkin');
+			send_wait(0, group_leader, 'checkin');
-				if (msg_error()) {
+			if (msg_error()) {
-					logf(ERROR, "error changing status to '%s' on Child %s %s from Parent %s %s - %s", p_statsym, c_type, c_num, p_type, p_num, msg[0]);
+				logf(ERROR, "error changing status to '%s' on Child %s %s from Parent %s %s - %s", p_statsym, c_type, c_num, p_type, p_num, msg[0]);
-				} else {
+			} else {
-					logf(SIGNIFICANT, "successfully set status to '%s' on Child %s %s from Parent %s %s", p_statsym, c_type, c_num, p_type, p_num);
+				logf(SIGNIFICANT, "successfully set status to '%s' on Child %s %s from Parent %s %s", p_statsym, c_type, c_num, p_type, p_num);
-−
+			}
+		}
+	}
 }</source>

@@ Line 77: / Line 77: @@
 === Step 2. Create the trigger ===
 This step is to create the trigger that will initiate the script. Use the [[Schema Designer]] utility to add the following code as a [[Site-Defined Trigger]] to the '''[[Act Log Table|alg (Request Activity Log)]]''' table.
-<source lang="javascript">POST_VALIDATE zstat_to_child() 111 FILTER(type{-> 'RE'} || type{-> 'ST'} || type{-> 'CL'});</source>
+<source lang="javascript">POST_VALIDATE zstat_to_child() 111 FILTER((type{-> 'RE'} || type{-> 'ST'} || type{-> 'CL'}) && zset_child_f == 1);</source>
 This trigger will activate when the Resolved (RE), Update Status (ST), or Closed (CL) Activities are initiated.

@@ Line 28: / Line 28: @@
 {{Create Spell Script}}
-<source lang="javascript">alg::zmyscript(...) {
+<source lang="javascript">alg::zstat_to_child(...) {
 	if (zset_child_f == 1) {
 		string c_desc, c_num, c_origstatsym, c_type, p_num, p_stat, p_statsym, p_type, wc;

@@ Line 88: / Line 88: @@
    };
 };</source>
 === Step 4. Edit the request_status_change.htmpl form ===

← Older revision		Revision as of 20:12, 27 October 2008
Line 102:		Line 102:

	== See Also ==		== See Also ==
		+	[[Propagate Solution to Children]]
	[[Set Request, Incident and Problem Status from Change Order]]		[[Set Request, Incident and Problem Status from Change Order]]

← Older revision		Revision as of 12:34, 31 August 2008
Line 100:		Line 100:
	=== Step 5. Publish the Schema changes ===		=== Step 5. Publish the Schema changes ===
	{{R11 Publish Schema Change}}		{{R11 Publish Schema Change}}
		+
		+	== See Also ==
		+	[[Set Request, Incident and Problem Status from Change Order]]