Problem with an If condition in a workflow.

[crhistopherjuar]

Hi Experts!

I have an Issue with an If condition in a workflow.

Here the scenario:

When all the Catalog Task are closed with the 'Close Complete' state, the workflow has to follow the 'Yes' path, and when all the Catalog Task are closed by a different state, the workflow has to follow the 'NO' path.

The IF activity has the next condition.

var rec = new GlideRecord('sc_task');

rec.addQuery('request_item', current.sys_id);

//rec.addQuery('state', '=' ,3);

rec.query();

while(rec.next()){

if (rec.state != 3){

answer = 'no';

}

else if (rec.state == 3){

answer = 'yes';

}

}

The execution of the answer 'NO' works, but when the execution answer is 'YES', both conditions are triggered at the same time.

I hope that you can help me.

Regards

Crhistopher

[Andrew Saxton -]

Are there any conditions running alongside the code in the if condition?

[Srinivas Balusu]

Is your workflow defined on Catalog Task table?

As per your query you are using request_item to query the Catalog Task table. Since it is a reference column to Requested items table, you might have multiple records resulting in you query in the above logic which is causing this.

You should uncomment //rec.addQuery('state', '=' ,3); in your script and modify the if-else conditions to check the rowCounts. Below is a sample of that.

var rec = new GlideRecord('sc_task');

rec.addQuery('request_item', current.sys_id);

rec.addQuery('state', '!=' ,3);

rec.query();

if (rec.getRowCount() > 0){

answer = 'no';

}

else if (rec.getRowCount() == 0){

answer = 'yes';

}

[crhistopherjuar]

Hi bsss,

still having the same problem.

[randrews]

ok i would do this a bit differently.

BEFORE your loop define the variable with a value of yes... then set and if   to set it to no if it finds a record.

var answer = 'no';

var rec = new GlideRecord('sc_task');

rec.addQuery('request_item', current.sys_id);

rec.addQuery('state', '!=' ,3);

rec.query();

if(rec.next()){

      answer = 'yes';

}