I am using Moodle 2.8. I have created two user field filters, one for lastname, the other for firstname. I am trying to return the courses that a selected user has taken. How do I reference those filters in the Custom SQL? I have tried:
...
WHERE 1
%%FILTER_USERS:u.lastname%%
%%FILTER_USERS:u.firstname%%
but when I select first or last names from the list, the report returns 0 records. The user has taken courses, so it should come back with that person's courses. Thank you.
