# Param dropdown for group\_id in data explorer query

**URL:** <https://meta.discourse.org/t/param-dropdown-for-group-id-in-data-explorer-query/253883>\
**Category:** Feature\
**Tags:** data-explorer, completed\
**Created:** [February 2, 2023, 8:03pm UTC](https://meta.discourse.org/t/param-dropdown-for-group-id-in-data-explorer-query/253883 "2023-02-02T20:03:10Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![pmusaraj](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pmusaraj/32/119489_2.png) [@pmusaraj](https://meta.discourse.org/u/pmusaraj)\
**Post date:** [March 12, 2024, 5:21pm UTC](https://meta.discourse.org/t/param-dropdown-for-group-id-in-data-explorer-query/253883/13 "2024-03-12T17:21:25Z")

</div>

Ask (and wait) and you shall receive… we just added support for a `:group_list` parameter in [this PR](https://github.com/discourse/discourse-data-explorer/pull/283).

Here is an example of the feature in use:

```plaintext
-- [params]
-- group_list :groups

SELECT g.id,g.name 
FROM groups g 
WHERE g.name IN (:groups) 
ORDER BY g.name ASC

```

That should give you the following in the UI:

 ![image](https://global.discourse-cdn.com/meta/original/4X/4/8/6/486c25ba68cc5da8d68a8e77ec40d5bd58ad4623.png)

---

_[View the full topic](https://meta.discourse.org/t/param-dropdown-for-group-id-in-data-explorer-query/253883)._