Moodle in English: how to SELECT a custom field in sql query

Configurable reports block (plugin)

how to SELECT a custom field in sql query

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

by Sheick Jaufuraully - Wednesday, March 20, 2019, 8:57 PM

Hi,

I am trying to create a report using SQL to show:

1) a custom field

2) Course Name

3) Date of completion

Can anyone please help me with this SQL Query, specially how do i SELECT a custom field which i created on moodle registration page for users.

Thank you