XF 2.1 Running reports on the Xenforo database

[carino]

I would love to see a set of canned reports that one could run on the Xenforo database. For example:

• A full report of all users with fields (columns) for name, userid, date joined, and even custom fields that I have in my registration

Does anyone know of an add-on for this? Or maybe provide me some guidance on building an SQL query ... I have very low skills with SQL queries.

Thanks,

Steve

 

[penturners]

Take a look at this site. When learning SQL years ago I visited there often.

SQL Tutorial

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

What specifically are you wanting to query? Which database are you using? Do you have direct database access via phpMyAdmin for example? Here's an example I posted in Another thread to get some user, profile, and custom field data.

SELECT
xf_user.user_id,
xf_user.username,
xf_user_field_value.field_value,
xf_user_profile.dob_day,
xf_user_profile.dob_month,
xf_user_profile.dob_year
FROM xf_user
LEFT JOIN xf_user_field_value ON xf_user.user_id = xf_user_field_value.user_id
LEFT JOIN xf_user_profile ON xf_user.user_id = xf_user_profile.user_id
WHERE xf_user_field_value.field_id='XXXXX'
ORDER BY xf_user.user_id ASC