I have a custom SQL report that displays Student name, enrollment type, enrolled on, course name, profilefiled1, profilefield2, etc on a custom moodle page. Instead of displaying whole data, I am trying to add drop-down filters like the Logs report so that I'll be able to download the report of a particular course or based on the profile field values. Can someone please tell me how to add drop-down filters to the report?
Moodle version: 3.10
Thanks in advance.