# Create dropdownlist choices from AD group or process Participant group members

**URL:** <https://discuss.workflowgen.com/t/create-dropdownlist-choices-from-ad-group-or-process-participant-group-members/1070>\
**Category:** General WorkflowGen Discussion\
**Created:** [June 14, 2018, 4:34pm UTC](https://discuss.workflowgen.com/t/create-dropdownlist-choices-from-ad-group-or-process-participant-group-members/1070 "2018-06-14T16:34:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![james](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@james](https://discuss.workflowgen.com/u/james)\
**Post date:** [June 14, 2018, 4:34pm UTC](https://discuss.workflowgen.com/t/create-dropdownlist-choices-from-ad-group-or-process-participant-group-members/1070/1 "2018-06-14T16:34:19Z")

</div>

I am wanting to create a dropdown with choices from a Participant group or our AD groups we assign to that participant group (to allow one participant to assign action steps to a specific person in another participant group). I’m still searching the documentation and forum for examples but have not found anything yet. Is this something I should do by querying in code-behind or a SQL stored procedure?

Thanks,

James

---

<div class="post-metadata">

**Author:** ![qpomarel](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/qpomarel/32/262_2.png) [@qpomarel](https://discuss.workflowgen.com/u/qpomarel)\
**Post date:** [June 15, 2018, 12:14pm UTC](https://discuss.workflowgen.com/t/create-dropdownlist-choices-from-ad-group-or-process-participant-group-members/1070/2 "2018-06-15T12:14:17Z")

</div>

Hello James,

You can write SQL query directly in dropdown list  
 ![image](https://canada1.discourse-cdn.com/flex030/uploads/workflowgen/original/1X/faa4681949e3dedfb4d2ee9c0d4e7b305042d320.png)

In our case, we set members in this list, which are in a participant group.

```
DECLARE @IdProcess int

SET @IdProcess = (SELECT TOP 1 ID_PROCESS FROM WFPROCESS
				WHERE NAME = 'PROCESS_NAME'
				ORDER BY ID_PROCESS DESC)

SELECT '' AS id, '- Sélectionner une personne ...' AS value
UNION
SELECT dbo.USERS.USERNAME as id,dbo.USERS.LASTNAME + ' ' + dbo.USERS.FIRSTNAME as value 
FROM dbo.WFPROCESS
INNER JOIN dbo.WFPARTICIPANT ON dbo.WFPARTICIPANT.ID_PROCESS = dbo.WFPROCESS.ID_PROCESS
INNER JOIN dbo.WFPARTICIPANT_MAPTO ON dbo.WFPARTICIPANT_MAPTO.ID_PARTICIPANT = dbo.WFPARTICIPANT.ID_PARTICIPANT				
INNER JOIN dbo.GROUPS ON dbo.WFPARTICIPANT_MAPTO.ID_GROUP = dbo.GROUPS.ID_GROUP
INNER JOIN dbo.USERS_GROUPS ON dbo.USERS_GROUPS.ID_GROUP = dbo.GROUPS.ID_GROUP
INNER JOIN dbo.USERS ON dbo.USERS.ID_USER = dbo.USERS_GROUPS.ID_USER
WHERE (dbo.WFPARTICIPANT.ID_PROCESS = @IdProcess) AND (dbo.WFPARTICIPANT.NAME = 'PARTICIPANT_NAME') AND dbo.USERS.ACTIVE = 'Y'
UNION
SELECT dbo.USERS.USERNAME as id,dbo.USERS.LASTNAME + ' ' + dbo.USERS.FIRSTNAME as value 
FROM dbo.USERS INNER JOIN
                         dbo.WFPARTICIPANT_MAPTO ON dbo.USERS.ID_USER = dbo.WFPARTICIPANT_MAPTO.ID_USER INNER JOIN
                         dbo.WFPARTICIPANT ON dbo.WFPARTICIPANT_MAPTO.ID_PARTICIPANT = dbo.WFPARTICIPANT.ID_PARTICIPANT
WHERE (dbo.WFPARTICIPANT.ID_PROCESS = @IdProcess) AND (dbo.WFPARTICIPANT.NAME = 'PARTICIPANT_NAME') AND dbo.USERS.ACTIVE = 'Y' 
ORDER BY value

```

You need to replace “PROCESS\_NAME” and “PARTICIPANT\_NAME’”.

After, we use “id” to affect action automatically

---

<div class="post-metadata">

**Author:** ![james](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@james](https://discuss.workflowgen.com/u/james)\
**Post date:** [June 15, 2018, 2:57pm UTC](https://discuss.workflowgen.com/t/create-dropdownlist-choices-from-ad-group-or-process-participant-group-members/1070/3 "2018-06-15T14:57:43Z")

</div>

Quentin,

Thank you for the response and code example. I will try out today or Monday and post a comment about what happened.

Thanks,

James

---

<div class="post-metadata">

**Author:** ![james](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@james](https://discuss.workflowgen.com/u/james)\
**Post date:** [June 15, 2018, 4:08pm UTC](https://discuss.workflowgen.com/t/create-dropdownlist-choices-from-ad-group-or-process-participant-group-members/1070/5 "2018-06-15T16:08:24Z")

</div>

Quentin,

Worked perfectly!!! I greatly appreciate it. Thank you!

James