I have a custom dropdown field setup on sign up where users select a ‘Category’ that best suits them. How can I find users based on what they selected within that dropdown?

To get all values for a named field, try this, with the name of your field entered into the field_name input: --[params] -- string :field_name WITH ucf_name AS( SELECT CONCAT('user_field_', id) AS name FROM user_fields WHERE name = :field_name ) SELECT u.id AS user_id, ucf.value FROM users u JOIN…

Trying to find the correct query to be able to search all users which have a custom user field Pro Email, but to find the users which are not in the Pro group?

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 …

Any example for a query on how to filter out users already in that group and then only return users not in that group? I have not used the data explorer plugin for Discourse that much.

[изображение] sebastianmoran: Any example for a query on how to filter out users already in that group and then only return users not in that group? Here’s one way to do it. It adds an excluded_users temporary table that’s made up of members of the excluded group. You will need to supply the …

[изображение] simon: –[params] – string :field_name – string :field_value – string :group_name WITH ucf_name AS( SELECT CONCAT(‘user_field_’, id) AS name FROM user_fields WHERE name = :field_name ), excluded_users AS ( SELECT gu.user_id FROM group_users gu JOIN groups g ON g.id = gu.group_id WHE…

What would need to defined in the field_value since I just need to have to process if it has a value set for the Pro Email user custom field?

If Pro Email is a confirmation field (checkbox) then setting the query’s field_value parameter to true will work. SInce all you are wanting to do is check that the field has been set, I think this version of the query will work better for you. It removes the field_value parameter and checks that th…

Hi @simon , which one of these queries would work if I had multiple custom fields and just wanted to return a list of users and their answers to those custom fields? I’ve got questions like “where did you hear about us” which has a checkboxes to allow for multiple choices, and another that asks how …

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

Создание сообщества Данные и отчетность

sebastianmoran (Sebastian Moran) 15.Январь.2020 03:48:42 3

Пытаюсь найти правильный запрос для поиска всех пользователей, у которых есть пользовательское поле «Pro Email», но которые не входят в группу «Pro»?

Тема		Ответов	Просм.
Displaying user custom fields in data explorer query results Data & reporting sql-query	5	1687	15.03.2020
Search with custom user fields Development rest-api	2	539	19.10.2023
New user filter by custom field and contact Support user-custom-fields	3	152	19.04.2026
Adding non-visible user custom fields to the API Site Management rest-api , how-to , user-custom-fields , users	2	1755	18.10.2023
Querying user_custom_fields Data & reporting sql-query , user-custom-fields	2	1020	15.06.2019

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

Связанные темы