Hi @LeoMcA ! I love this query of yours that you created last year to use the data explorer to display a chronological list of user topics started, replied and liked . Would you be willing to update the query to also optionally include user custom fields in the results? It would be a big help to me ri…

Sure, should be a pretty trivial change. I should get it done by the end of next week… hope you can wait until next year! :wink: Been pretty busy with Uni, but I can’t really complain about that - hope you’ve had a good holiday season too :slight_smile:

That’s great news, thanks Leo! I really appreciate it. Glad to hear you’re keeping well and busy with school, and enjoying the holidays. All is well on my end. I’m a bit sad to see the end of a nice break from work but am also looking forward to getting back into things at Namati. I’m working on a…

Here we go: -- [params] -- date :date_from = 1970-01-01 -- date :date_to = 2038-01-19 -- boolean :guess_domain = true -- string :domain = https://example.com WITH ss AS ( SELECT CASE WHEN :guess_domain = true THEN concat('https://', split_part(value, '@', 2)) ELSE :domain END AS domain…

[image] LeoMcA: There’s probably a way to do this automatically, but I’m not enough of a SQL guru to work it out :wink: I’ve found that query really helpful for our site, but it took a while to customise / hack, make it work by group, and include some other user stuff like emails. However, I…

Displaying user custom fields in data explorer query results

Community Building Data & reporting

tobiaseigen (Tobias Eigen) January 6, 2018, 12:06am 5

Fantabulous. thanks, @LeoMcA! Works perfectly. Really all I want is the wordpress user ID for matching. It’s stored as a custom user field.

Topic		Replies	Views
Create a report of users including custom fields Data & reporting	0	1097	November 17, 2020
Search with custom user fields Development rest-api	2	539	October 19, 2023
Adding non-visible user custom fields to the API Site Management rest-api , how-to , user-custom-fields , users	2	1763	October 18, 2023
Complex user activity report requirement Data & reporting sql-query	22	2235	August 5, 2021
Query to filter users by sign-up 'custom fields' Data & reporting sql-query , user-custom-fields	11	1848	January 17, 2022

Displaying user custom fields in data explorer query results

Related topics