Taks participant list
I have a task for a specific price and it should be approved by a manager and then one of the directors in an order. I get a list of director from the database and an approve from one of the directors is enough. I assign director list to a repeatable process field and then this process field should become participant list for the task but the only first one of the director list become a participant.
-
How are you assigning your participants to the task? I'm not sure that it is possible to assign a repeating element as a task participant. My suspicion is that when you do that, it is only going to pull the first entry in the list and that is who would get assigned the task.
If your list of Directors does not change often, you could setup a user group for the Directors and then assign that group as the task participants:
-
My suspicion is that when you do that, it is only going to pull the first entry in the list and that is who would get assigned the task.
Your suspicion is absolutely true. When I tried to do this only first user has been assigned. There are five or six director and according to the task specification I must choose one or two (maybe three) of them. Therefore I can not use the way that defines user group.
-
Hi Mehmet,
If you assign participants with semicolon delimited then it would assign it to group of people.
Let me show you example how i did it in my sample application .
1. I have table named Directors which is having two columns UserName and Full Name
2. I have written SQL Query to return all the director user names with semicolon delimiter
ex : SELECT STRING_AGG(UserName, '; ') FROM [TestDB].[dbo].[Directors]
3.Use Query Record Activity to execute the query and assign to a process variable
4. On Participant screen for Human Activity assign this variable.
Thanks,
Venkat
-
Dear Venkat,
Thanks for your suggestion but it also doesn't help me. I created a "query record" with selecting and aggregating the string of director registration number. But when I inspect the process variable, it is empty. I tried my selecting and aggregating query in SQL server management studio directly but it's not working because of the lack of string_agg in the version. Does this cause the problem because of the on-prem Agilepoint in our company?
Best Regards
Eren
-
Hi Mehmet,
Yes you are correct string_agg function available only on latest version of SQL Server.
As a alternative for older version can you use below query.
DECLARE @listUser VARCHAR(MAX)
SELECT @listUser = COALESCE(@listUser+';' ,'') + UserName
FROM [TestDB].[dbo].[Directors]
SELECT @listUserCan you use above query .
Thanks,
Venkat
Please sign in to leave a comment.
Comments
6 comments