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
Overview Pluto LMS stores all LMS data in an SQL database on a secure server. The Custom Reports tool provided by Pluto LMS allows you to query this database in order to create custom reports as required by your organisation. Note: Pluto LMS does not ...
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. USE CASE EXAMPLE: Improving Onboarding Training Company: XYZ Corporation ...
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 ...