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.

[image] 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 group’…

[image] 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 WHERE g.n…

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 …

Requête pour filtrer les utilisateurs par « champs personnalisés » d'inscription

Communauté Données et rapports

sebastianmoran (Sebastian Moran) Janvier 15, 2020, 3:48 3

Essayer de trouver la requête correcte pour rechercher tous les utilisateurs ayant un champ utilisateur personnalisé « Pro Email », mais qui ne font pas partie du groupe Pro ?

Sujet		Réponses	Vues
Displaying user custom fields in data explorer query results Data & reporting sql-query	5	1687	Mars 15, 2020
Search with custom user fields Development rest-api	2	539	Octobre 19, 2023
New user filter by custom field and contact Support user-custom-fields	3	152	Avril 19, 2026
Adding non-visible user custom fields to the API Site Management rest-api , how-to , user-custom-fields , users	2	1755	Octobre 18, 2023
Querying user_custom_fields Data & reporting sql-query , user-custom-fields	2	1020	Juin 15, 2019

Requête pour filtrer les utilisateurs par « champs personnalisés » d'inscription

Sujets connexes