# 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:** 25

<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 18, 2024, 7:12pm UTC](https://meta.discourse.org/t/param-dropdown-for-group-id-in-data-explorer-query/253883/25 "2024-03-18T19:12:41Z")

</div>

> [@ganncamp](#):
>
> Is there a way to limit the new `-- group_list` parameter type to a single group?

No, there’s no way to limit it to a single group. Not that I know of.

The parameter from `group_list` will be an array if there is more than 1 item selected and a string if only 1 item is selected.

So when there is just one item, you _can_ do this:

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

SELECT g.id,g.name 
FROM groups g 
WHERE g.name = :groups 
ORDER BY g.name ASC

```

But since it’s an array, this below will work for both a single item and multiples:

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

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

```

But there is no way to tell the UI “only accept 1 item as the selection”.

---

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