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.

[immagine] 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 gro…

[immagine] 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 …

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 per filtrare gli utenti in base ai "campi personalizzati" di registrazione

Comunità Dati e reportistica

sebastianmoran (Sebastian Moran) 15 Gennaio 2020, 3:48am 3

Sto cercando la query corretta per poter cercare tutti gli utenti che hanno un campo utente personalizzato “Pro Email”, ma per trovare gli utenti che non sono nel gruppo Pro?

Argomento		Risposte	Visualizzazioni
Displaying user custom fields in data explorer query results Data & reporting sql-query	5	1687	Marzo 15, 2020
Search with custom user fields Development rest-api	2	539	Ottobre 19, 2023
New user filter by custom field and contact Support user-custom-fields	3	152	Aprile 19, 2026
Adding non-visible user custom fields to the API Site Management rest-api , how-to , user-custom-fields , users	2	1755	Ottobre 18, 2023
Querying user_custom_fields Data & reporting sql-query , user-custom-fields	2	1020	Giugno 15, 2019

Query per filtrare gli utenti in base ai "campi personalizzati" di registrazione

Argomenti correlati