how to call a multi row variable sets variable inside the workflow

Sri56 · ‎03-28-2022

Hi Team,

I have created a muti row variable set called-'workflow'

where i have workflow, approver and cc variables as below:

How to call this variables inside the workflow.

In other words, i need to use approver and cc as approvers inside the workflow.

Please help me.

Thanks,

Srivalli M

Murthy Ch · ‎03-29-2022

I hope your workflow is running on RITM table if yes the below code will work

Just now tested in my PDI as well.

Keep some logs and try and let me know what logs you have got:

answer = [];
var mrvs = current.variables.workflow;      //use MRVS internal name
for (var i = 0; i < mrvs.getRowCount(); i++) {
    var row = mrvs.getRow(i);                  // getting the row one by one using getRow
    gs.info("approver"+row.approvers);
    gs.info("cc"+row.cc);
    answer.push(row.approvers.toString());      //sending approval to approvers users
    answer.push(row.cc.toString());      //sending approval to cc users & map your variable names
    }
}

Thanks,

Murthy

Thanks,
Murthy

View solution in original post

Murthy Ch · ‎03-28-2022

Hi Sri,

Please refer my Article same explained here.

Thanks,

Murthy

Thanks,
Murthy

Sri56 · ‎03-28-2022

Hi Murthy,

As you see my table below

I want to add approvers and cc users as approvers in the workflow.

Can i please get the code?

Please help.

Thanks,

Srivalli

Murthy Ch · ‎03-28-2022

Hi Srivalli,

Try something like this in your Approval activity:

answer = [];
var mrvs = current.variables.MRVS_internalname;      //use MRVS internal name
for (var i = 0; i < mrvs.getRowCount(); i++) {
    var row = mrvs.getRow(i);                  // getting the row one by one using getRow
    answer.push(row.u_approvers.toString());      //sending approval to approvers users
    answer.push(row.u_cc.toString());      //sending approval to cc users & map your variable names
    }
}

Hope it helps.

Thanks,

Murthy

Thanks,
Murthy

Sri56 · ‎03-28-2022

Hi Murthy,

Approval stage is skipping as below:

Please help.

Thanks,

Srivalli