Can you use data in a global list to assign the next participant?


#1

We have a Global List containing requester userIDs and associated Supervisors, managers, team coordinators etc.
Is there a way to use this info to dynamically assign participants in the workflow for each requester?


#2

Hello David,

You can add an hidden field which you can insert user id of next participant.

You can fetch datas from your global list with following code:

    WorkflowGen.My.Integration.GlobalLists gl = new WorkflowGen.My.Integration.GlobalLists();
    System.Data.DataTable GLOBAL_LIST_DATA;
    GLOBAL_LIST_DATA = gl.fetchList("YOUR_GLOBAL_LIST", "COLUMN_NAME1,COLUMN_NAME2", "en-US","value","Equals",YOUR_DROPDOWNLIST.SelectedValue,true);
    HIDDEN_MANAGER_ID.Text = GLOBAL_LIST_DATA.Rows[0]["COLUMN_NAME1"].ToString();
    HIDDEN_SUPERVISOR_ID.Text = GLOBAL_LIST_DATA.Rows[0]["COLUMN_NAME2"].ToString();

You can find an example here : Form Designer: How to bind a text box field to a global list

Quentin


#3

Ok, thanks Quentin,

I have that working now

Cheers