how to access a custom field in SQL

how to access a custom field in SQL

by Sheick Jaufuraully -
Number of replies: 1

Hi 


I would appreciate if anyone could help me with this. I created a custom field named ProfileID on the moodle registration page. I need to create an SQL report to pull the data from that field. Can anyone please tell me how to do this? Also where can i find the custom field names as moodle saved it on the SQL database?


Many Thanks

S

Average of ratings: -
In reply to Sheick Jaufuraully

Re: how to access a custom field in SQL

by Darko Miletić -

All custom fields definitions are stored in user_info_field table. The data stored in those fields for every user is stored in user_info_data. Of course in you specific database all these tables would have prefix which is usually mdl_ so mdl_user_info_field and mdl_user_info_data.



Average of ratings: -