I’m trying get a list of all users that do not have ticked a specific custom user field. I managed to get a list of those who have ticked it, but I can’t seem to do the inverse: SELECT cf.user_id FROM user_custom_fields cf WHERE cf.name like 'user_field_5' AND cf.value = 'true' For example, cf.val…

This is because a row is only added to the user_custom_fields table after a user has changed the value. So what you want to do is Go through the users table For each user, see if there’s a user_custom_fields row for user_field_5 If so, check whether it’s true, otherwise assume it’s false In my te…

Boolean custom fields are stored as "t" and "f" in the database. [画像] tophee: BTW, I found it confusing that the datatype of a confirmation type user field is not boolean but text. I figure it’s to keep the user field table simple with just one data type? That’s because all custom fields are…

[画像] zogstrip: Boolean custom fields are stored as “t” and “f” in the database. Aah, will try that when I’m back at my desk. But what I don’t understand then is why cf.value = 'true' worked…

Not sure, maybe the field isn’t properly “serialized” and we’re saving in the database true.to_s.

[画像] zogstrip: Boolean custom fields are stored as “t” and “f” in the database Unfortunately, this doesn’t work for me: SELECT cf.user_id FROM user_custom_fields cf WHERE cf.name like 'user_field_5' AND cf.value = 'f' It yields zero results.

How to query a confirmation-type custom user field?

Support

tophee (Christoph) 2017 年 8 月 20 日午前 10:41 3

Aah, will try that when I’m back at my desk. But what I don’t understand then is why cf.value = 'true' worked…

トピック		返信	表示
Query to filter users by sign-up 'custom fields' Data & reporting sql-query , user-custom-fields	11	1840	2022 年 1 月 17 日
Trying to query to find user custom fields filled out Data & reporting sql-query , user-custom-fields	3	1100	2018 年 5 月 1 日
Trust level 0 + custom field badge Data & reporting sql-triggered-badge	1	822	2021 年 2 月 20 日
Querying user_custom_fields Data & reporting sql-query , user-custom-fields	2	1014	2019 年 6 月 15 日
Adding non-visible user custom fields to the API Site Management rest-api , how-to , user-custom-fields , users	2	1744	2023 年 10 月 18 日

How to query a confirmation-type custom user field?

関連トピック