Custom Query

The Custom Query Data Source allows you to create Reports in the Craft Control Panel using a Custom MySQL Query.

# Query all data in the Users table

SELECT *
FROM users;

Example assumes you setup Craft with the default database table naming conventions.