# Query to filter users by sign-up 'custom fields'

**URL:** <https://meta.discourse.org/t/query-to-filter-users-by-sign-up-custom-fields/100837>\
**Category:** Data & reporting\
**Tags:** sql-query, user-custom-fields\
**Created:** [October 30, 2018, 1:50am UTC](https://meta.discourse.org/t/query-to-filter-users-by-sign-up-custom-fields/100837 "2018-10-30T01:50:50Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [January 15, 2020, 6:14pm UTC](https://meta.discourse.org/t/query-to-filter-users-by-sign-up-custom-fields/100837/4 "2020-01-15T18:14:30Z")

</div>

I moved your post to this topic. I _think_ the last query in my previous post in this topic will get you close to what you are looking for. If your custom field is a confirmation type, enter ‘true’ for the `field_value` parameter. That will return all users who have checked the confirmation box for the field name you supply for the query’s `field_name` parameter.

The query will need to be added to so that you can filter out users who are already in your Pro group.

---

_[View the full topic](https://meta.discourse.org/t/query-to-filter-users-by-sign-up-custom-fields/100837)._