How to add drop down filters

How to add drop down filters

by Sarath P -
Number of replies: 1

Hello everyone,

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.

Average of ratings: -
In reply to Sarath P

Re: How to add drop down filters

by Sarath P -
Please find the below screenshot of a test report.  I am trying to add a start date and end date filter next to download so that I could select a date range and get the data within the range.

Average of ratings: -