Taks participant list

Comments

6 comments

  • Avatar
    Loren Bratzler

    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:

    0
    Comment actions Permalink
  • Avatar
    Mehmet Eren

    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. 

     

    0
    Comment actions Permalink
  • Avatar
    AgilePoint NX Support

    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

     

     

    1
    Comment actions Permalink
  • Avatar
    Mehmet Eren

    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 

    0
    Comment actions Permalink
  • Avatar
    AgilePoint NX Support

    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 @listUser

    Can you use above query . 

     

    Thanks,

    Venkat 

    1
    Comment actions Permalink
  • Avatar
    Mehmet Eren

    It works fluently.

    Thanks a lot Venkat.

    0
    Comment actions Permalink

Please sign in to leave a comment.