Workflow on "sc_request" with reference to "sc_req_item"

[Maki]

Hello all,

i created a workflow on "sc_request" where an event gets started after an "if-statement". 
For that i created two boolean user variables, one at "sc_cat_item" called "u_direktversand_cat" the other at "sc_req_item" called "u_direktversand_item".
A Business Rule set the value on "sc_req_item" to true, if the variable is true in the item at "sc_cat_req" (works fine)

But my conditions always gets "no". In the condition i have to reference the requested item (sc_req_item).

Here is my condition:

answer = ifScript();
function ifScript() {
var gr = new GlideRecord('sc_req_item');
gr.addQuery('request',current.sys_id);
gr.query();
while(gr.next()){
if (gr.variables.u_direktversand_item == 'true'){
return 'yes';
}
return 'no'; 
}
}

Any ideas? Thanks at all

[Steven Slocum]

Glad to hear. Please mark the comment if correct if all is cleared up.

[Maki]

If you have multiple RITMs under a given REQ, this could cause issues.

Here is my final solution with another if-statement that checks if any item is false. In this case the no condition is selected. 

answer = ifScript();
function ifScript() {
	var gr = new GlideRecord('sc_req_item');
	var direkt = 'yes';
	gr.addQuery('request',current.sys_id);
	gr.query();
	while(gr.next()){
		if (gr.cat_item.u_direktversand == true){
			if (direkt == 'yes'){
				direkt = 'yes';
				}
			else direkt = 'no';
		}
		else direkt = 'no';
	}
	if (direkt == 'yes'){
		return 'yes';
		}
    return 'no';	

}

If there is a better solution let me know 🙂

[RichGK1]

Try this

gr.addQuery('sc_request',current.sys_id);