I have a data explorer query where I am trying to find all who have filled out user custom field 1-4, and would love it to only show those with all 4 as columns for each user, but my postgre skills are limited and I haven’t been able to figure it out: SELECT user_id, name, value FROM user_custom_fi…

I’m sure there are better ways of approaching this, but this should work to give you a single row containing all of the fields for each user who has filled out at least one of your user fields. WITH user_field_1 AS ( SELECT ucf.value, ucf.user_id FROM user_custom_fields ucf WHERE ucf.name = 'user_f…

By ‘better’ I mean more elegant and more efficient. This should give you the results that you are looking for. I was stuck for a while on how to get the results in a single row for each user. If that isn’t a requirement, the query could be simplified a lot.

ユーザーのカスタムフィールドの入力状況を確認するクエリを試行中

コミュニティデータとレポート

jerdog (Jeremy M) 2018 年 4 月 30 日午後 11:53 4

If there is a better way I am so ok with trying/doing it! I’ll give this a shot though.

トピック		返信	表示
Query to filter users by sign-up 'custom fields' Data & reporting sql-query , user-custom-fields	11	1851	2022 年 1 月 17 日
Querying user_custom_fields Data & reporting sql-query , user-custom-fields	2	1024	2019 年 6 月 15 日
How to query a confirmation-type custom user field? Product Support	5	1373	2017 年 8 月 20 日
Report on User Fields? Product Support	3	1176	2019 年 8 月 14 日
Displaying user custom fields in data explorer query results Data & reporting sql-query	5	1703	2020 年 3 月 15 日

ユーザーのカスタムフィールドの入力状況を確認するクエリを試行中

関連トピック