Custom Reports
SQL Templates
Note that assistance with writing SQL queries is not within Pluto LMS support scope. Please contact a developer for assistance. That being said, you can use the templates provided below to help you get started. Please review our other guides for more ...
SQL Query Basics
Below is an example of a very basic SQL query: SELECT u.id AS 'id', u.username AS 'username', u.firstname AS 'first name', u.lastname AS 'last name', u.email AS 'email' FROM prefix_user AS u WHERE u.id > 2 The SELECT statement is used to select data ...
Database Structure
Visualising the Pluto LMS Database: The below graphic will help you visualize how each database table connects to the other. Some important notes: This is a simplified graphic and in many instances you can have more than one connection across tables. ...
Creating a Custom Report
OVERVIEW The Custom Reports module allows you to create custom reports to supplement the native Pluto LMS reports. Note: This may require the assistance of a developer. CREATE A CUSTOM REPORT Step 1: Click on "Site admin", followed by "Site ...
Adding Filters
OVERVIEW When creating a custom report, you can add filters that function as a control which produces a subset of data. ADDING A FILTER In the relevant custom report, in the "Filters" tab, select the filter that you require from the "Add" drop-down ...
Popular Articles
Understanding the Pluto LMS Support Scope
We love our clients and place high priority on providing the best possible customer support. Channels of Support There are multiple channels of support and, as such, an important part of providing our clients with responsive and comprehensive support ...
Create a Single Course
OVERVIEW Users with the "Site Admin" or "Course Creator" roles can create new courses and define course settings. CREATE A COURSE Step 1: Click on "Create course" in your left navigation menu. Alternatively, you click on "Site admin", followed by ...
Video Tutorials
Watch Our YouTube Playlist Below You can select and navigate to individual videos from the top right icon. If you would prefer to watch this on YouTube, click here .
Reports API
block_configurable_reports_get_report_data Arguments reportid (Required) The report id General structure int //The report id REST (POST parameters) reportid= int How to connect to 3rd party data analysis tools: You can also connect to tools like: ...
Create Course Categories
OVERVIEW Course categories organize courses for all your LMS users. CREATE COURSE CATEGORIES Step 1: Click on "Site admin", followed by "Course management", then "Create category." Step 2: Define your category settings. (1) Set "Parent category" as ...