Report on User Fields?

#1

I’ve added one User Field, editable and shown on profile. I’d like to see a list of users who have provided it, with the values. Is this possible?

I found this old topic which seems to indicate it is not, but I’m hoping there’s newer information.

Thanks!

#2

My super-geeky workaround for now: download a backup, and grep the .sql file for “user_field_1”…

#3

If you’re an admin, you can check this out. Lets you run queries against your db.

3 Likes
#4

Thanks, the Data Explorer plugin works nicely. The query I used was:

SELECT user_id, value from user_custom_fields where name = 'user_field_1'

(though user_field_1 is particular to my site…)

2 Likes
#5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.