[Stefan71]

Hi all,
I want to create an sql query over users - table and assign the result to next step parallel task. I believe I have to somehow convert result of query to user array. Any help would be nice.

best regards.

[AlanBueno]

hello,
im not sure if i understand your problem, are you trying to use a query to get a list of users, and then assign those users to the parallel task that comes next?

[amosbatto]

If you want to create array of the users for assignment in a task with a parallel marker, then the trigger code would be something like this:

Code: Select all

$sql = "SELECT USR_UID FROM USERS";
$aUsers = executeQuery($sql)
@=userList = array();
foreach ($aUsers as $aUser) {
   @=userList[] = $aUser['USR_UID'];
} 

where @@userList is the variable for user assignment.

You can add a WHERE clause to your query.

[Stefan71]

I tried your code, I get following error:

The activity act_uid: "1518537455ac7720138f2e6057468491", has an invalid user-data in "userList" or this variable doesn't exist for a multi-instance activity

[amosbatto]

Oh, I see that I forgot a semicolon in the trigger code.
It should be:

Code: Select all

$sql = "SELECT USR_UID FROM USERS";
$aUsers = executeQuery($sql);
@=userList = array();
foreach ($aUsers as $aUser) {
   @=userList[] = $aUser['USR_UID'];
} 
 

If you turn on Debug Mode in the Process properties you can debug these problems.

Here is a sample process to test it:

test_parallel_marker-1.pmx

(31.96 KiB) Downloaded 236 times

[Stefan71]

I tested your workflow, this is the solution, thank you.

[amosbatto]

If you want to assign all the users in a particular group to the task with a parallel marker, you can use this trigger code:

Code: Select all

$groupName = "Approval Group";
$groupId = PMFGetGroupUID($groupName);
if (empty($groupId)) {
  throw new Exception("Group '$groupName' doesn't exist.");
}
$aUsers = PMFGetGroupUsers($groupId);
@=userList = array();

foreach ($aUsers as $aUser) {
   @=userList[] = $aUser['USR_UID'];
}