MBPM V9 Dynamic Roles

Ballon_Pierre

Hi all,

I'm trying to address a list of user (Using SelectSQL) to a process variable so it grants these users the targeted dynamic role (as we were doing in version 7).

MyRole is populated by a Map1Data.memMyVariable.

I can't fix it, I only recover the first member of the list of user.
Does anyone have a clue, it was so obvious in version 9.

Pierre

Ballon_Pierre

I finally have found a solution, here it is:

memTDLUser= SelectSQL(Select eUserName from eUser Where ....)
Create a server script method

public static List ReturnCleanList(string MyList)  
{  
    string MyReturnList="";  
    MyReturnList=MyList.Replace("\t",",");  
    MyReturnList=MyReturnList.Replace("\n",String.Empty);  
    MyReturnList=MyReturnList.Replace("\r",String.Empty);    
    return List.Convert(MyReturnList.Split(','));  
}  

Use it in the formula Role : ServerScript1.ReturnCleanList(MyProcessData.memTDLUser)

Marcin Pacyga

thank you Pierre for sharing!