User Profile Fields in SQL Configurable reports (3.5)

User Profile Fields in SQL Configurable reports (3.5)

by Melenie Marsh -
Number of replies: 3

We have created 6 user Profile Fields as required for reporting in our organisation.

We want to create some SQL reports using these fields, but are unable to identify what these fields are called in SQL terms.

For example, the Profile Field "Job Title" returns an error if the SQL contains u.jobtitle and every other spelling with/without capital letters. 

Any help would be much appreciated

Average of ratings: -
In reply to Melenie Marsh

Re: User Profile Fields in SQL Configurable reports (3.5)

by m question -

which table?

please see this thread

Average of ratings: -
In reply to m question

Re: User Profile Fields in SQL Configurable reports (3.5)

by Melenie Marsh -

Hi, I think that is part of the problem. I don't know which table these fields have gone into. They were added in Site Administration>Users>Accounts>User Profile Fields>Other Fields.


I don't have access to the server.

Average of ratings: -
In reply to Melenie Marsh

Re: User Profile Fields in SQL Configurable reports (3.5)

by C Behan -

Hi Melenie


  • The table listing the added user profile fields is user_info_data
  • The table showing which users are using the additional fields is user_info_field

You might find http://www.examulator.com/er/ useful

Also, you can retrieve a list of your Moodle site's tables using this query:

SELECT table_name FROM information_schema.tables
Average of ratings: Useful (3)