question Issue with workflow condition based on a list collector variable in Community Central forum

Issue with workflow condition based on a list collector variable

Sue143 — Thu, 22 Aug 2024 22:19:21 GMT

Hi all,

I am trying to get an yes or no answer on my workflow based on a list collector values, which are reference from a custom table.

What I need to achieve is to identify the values selected in the list collector and based on these values do something like dot walking to get which change group is related to that value in the table.

This is my script, but so far does not return any value, can someone help me and put me in the right direction?

answer = ifScript();

function ifScript() {

var collector = current.variables.my_variable.toString(); //get variable name from catalog item

var list = collector.split(",");

for (var i = 0; i < list.length; i++) {

var gr = new GlideRecord('my_custom_table'); //access the custom table that store the values from List collector

gr.addQuery('u_change_group=dcfb023edb4d1340439d14a05b9619c5'); //define the change group with sys_ID

if (gr.get(list[i]))

return 'yes';

else

return 'no';

}

Re: Issue with workflow condition based on a list collector variable

brianlan25 — Thu, 22 Aug 2024 22:44:58 GMT

Try this, if you know what specific sys_id you are looking for you can just use indexOf.

answer = ifScript(); function ifScript() { var collector = current.variables.my_variable.toString(); //get variable name from catalog item var list = collector.split(","); if (list.indexOf('dcfb023edb4d1340439d14a05b9619c5') > -1) return 'yes'; else return 'no'; }

Re: Issue with workflow condition based on a list collector variable

Brad Bowman — Thu, 22 Aug 2024 22:52:08 GMT

Hello,

The first issue is with the addQuery - you can either use

gr.addQuery('u_change_group', 'dcfb023edb4d1340439d14a05b9619c5'); //define the change group with sys_ID

gr.addEncodedQuery('u_change_group=dcfb023edb4d1340439d14a05b9619c5'); //define the change group with sys_ID

Secondly, there is likely a logic problem as the script will end with the first list collector entry. It's a little unclear what you're trying to do with the list collector values, but if you are wanting to loop through all of the list collector entries, then return the value if ANY of them match the change group, it would look something like this:

answer = ifScript(); function ifScript() { var answer = 'no'; var collector = current.variables.my_variable.toString(); //get variable name from catalog item var list = collector.split(","); for (var i = 0; i < list.length; i++) { var gr = new GlideRecord('my_custom_table'); //access the custom table that store the values from List collector gr.addQuery('u_change_group', 'dcfb023edb4d1340439d14a05b9619c5'); //define the change group with sys_ID if (gr.get(list[i])) answer = 'yes'; } return answer; }

Re: Issue with workflow condition based on a list collector variable

Sue143 — Fri, 23 Aug 2024 01:59:42 GMT

Hi Brad, thank you for your response.

I have tried your code but is still not working.

The workflow does not end up in an error, but the if condition returns true every time, even when it shouldn't.

I am trying to loop through, not all, but only the values selected by the user from the list collector and decide with an if condition statement if these selected values have as change group the one defined on the code:

('u_change_group', 'dcfb023edb4d1340439d14a05b9619c5')

and if not, the answer to the if statement should be no, but this is not happening in the moment.

the workflow I am building depends on this if condition to create a task and assign to this change group in case it is "true". Otherwise, this should be skipped. But right now it is creating the task even when the change group of the value select is other.

Re: Issue with workflow condition based on a list collector variable

Sue143 — Fri, 23 Aug 2024 02:06:03 GMT

Hi Brian, thank you for your response but this is not enough to solve my issue, the list collector is getting the values from a custom table.

The sys_id is not of the value available in the list collector but of the change group associated with the value of the list collector.

I need to get the value from the list collector and access it on the custom table to find out if the change group assigned is the one of the sys_id.

Re: Issue with workflow condition based on a list collector variable

Brad Bowman — Fri, 23 Aug 2024 17:50:36 GMT

The next step is to temporarily add some log lines to the script so you can see what is happening. It also sounds like this would be better with a more conventional approach - return all of the list collector records, then test each for the condition match. Also, I shouldn't have used 'answer' as a script variable since it is already a part of the if activity.

answer = ifScript(); function ifScript() { var collector = current.variables.my_variable.toString(); //get variable name from catalog item workflow.info('collector = ' + collector); //verify the variable was retrieved var gr = new GlideRecord('my_custom_table'); //access the custom table that store the values from List collector gr.addQuery('sys_id', 'IN', collector); gr.query(); while (gr.next()) { workflow.info('Record found ' + gr.sys_id + ' Group = ' + gr.u_change_group); //change this to a more descriptive field on the custom table if (gr.getValue('u_change_group') == 'dcfb023edb4d1340439d14a05b9619c5') { //define the change group with sys_ID workflow.info('Group matched'); return 'yes'; //stop running the script when the first group match is found } } workflow.info('No list collector record had a matching group'); return 'no'; //if no groups matched, take the No path }

Be sure to test this workflow change with a newly-submitted record. You can view these logs on the Log tab while viewing the context from the Related Link at the bottom of the RITM.

Re: Issue with workflow condition based on a list collector variable

brianlan25 — Fri, 23 Aug 2024 14:20:03 GMT

If the list collector is pointing to a custom table then the only thing you can select is from that custom table. If the custom table has change group in it and that is all you can select then the all the sys_id in the list collector will be from a change group.

Re: Issue with workflow condition based on a list collector variable

Sue143 — Fri, 23 Aug 2024 17:33:57 GMT

Hi Brad,

Thank you so much for the time you taking to help me, but it still not working.

The logs shows that the code works fine to find a match for the collector on the table, but it also say "group matched" for all the 3 if conditions on my workflow:

each if condition matches a different change group (different sys_id), so it shouldn't match all unless I it is selected multiple values in the list collector, which I haven't for testing purposes.

this is the log results, each record (role) only have a change group, so it should return true for only one of the if conditions

Re: Issue with workflow condition based on a list collector variable

Brad Bowman — Fri, 23 Aug 2024 17:51:33 GMT

So just to confirm, you are using the same script in all three if activities, only changing this line to a different sys_id?

        if (gr.getValue('u_change_group') == 'dcfb023edb4d1340439d14a05b9619c5'); //define the change group with sys_ID

I just noticed I'm missing a { on this line - I just corrected it in the full script above, and added group to the log. Not sure if that accounts for this behaviour, or if you previously corrected this.

Re: Issue with workflow condition based on a list collector variable

Sue143 — Fri, 23 Aug 2024 18:01:28 GMT

Thank you Brad!!!!!

I actually didn't noticed either, after correcting the missing comma the code works.

and yes, I am using the same script for all the 3 if conditions just modifying the sys_id to match each change group.

Re: Issue with workflow condition based on a list collector variable

Brad Bowman — Sat, 24 Aug 2024 14:00:25 GMT

Great to hear, happy to help!

Connect with me https://www.linkedin.com/in/brad-bowman-321b1567/