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 group’s N…

[图片] 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.name…

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 …

按注册“自定义字段”筛选用户的查询

社区数据与报告

sebastianmoran (Sebastian Moran) 2020 年1 月 15 日 03:48 3

尝试找到正确的查询语句，以搜索所有具有自定义用户字段“Pro Email”但不在“Pro”组中的用户。

话题		回复	浏览量
Displaying user custom fields in data explorer query results Data & reporting sql-query	5	1687	2020 年3 月 15 日
Search with custom user fields Development rest-api	2	539	2023 年10 月 19 日
New user filter by custom field and contact Support user-custom-fields	3	152	2026 年4 月 19 日
Adding non-visible user custom fields to the API Site Management rest-api , how-to , user-custom-fields , users	2	1755	2023 年10 月 18 日
Querying user_custom_fields Data & reporting sql-query , user-custom-fields	2	1020	2019 年6 月 15 日

按注册“自定义字段”筛选用户的查询

相关话题