Custom data sources

Developers can tap into the power of SQL queries to craft bespoke data sources, providing precise access to Moodle’s extensive database.

In the initial phase of data source creation, developers can define a unique name and ID number for the data source, as well as select a primary table from the available options. This primary table serves as the foundation for the data source.

Within the Join Tables section, developers can establish intricate relationships between multiple tables, enriching the data source with diverse datasets to meet specific project requirements.

In the Fields Setup section, developers configure the selection of fields for the data source, ensuring the inclusion of relevant information. The “Additional Format Value” option allows developers to embed custom static content within the field transform format.

By leveraging these options effectively, developers can tailor the selection and presentation of fields within their data source to meet specific formatting requirements and user preferences.

The Conditions Setup section enables developers to define conditions for the data source, facilitating the extraction of specific data subsets based on predefined criteria.

Once created, datasources are listed in the datasources section of the Block Dash configuration. Configuring a datasource within the Dash block involves setting up the block to fetch data from the created datasource.

Creating custom data sources with Dash Developer.

Full list of features

	Basic	Plus	Pro	Premium
Highly customizable blockfeatured Fine-tuning Dash blocks visually and enhancing user experience.
Usable everywhere Dash is a versatile block type that seamlessly integrates into any available block region within your LMS.	✔	✔	✔	✔
Combining dynamic and static content Incorporating static content alongside the dynamic core information of a Dash block can greatly enhance user experience.	✔	✔	✔	✔
Styling options A range of customization options is available to craft a distinctive appearance.	✔	✔	✔	✔
Empty state handling In cases where no data is available for the defined Dash, admins can integrate fallback content or hide blocks.	✔	✔	✔	✔
Visual content blocks Selection of layouts for static content offering multiple customizable content fields.
Layouts Layouts for static content with a different number and arrangement of content fields.		✔	✔	✔
Course section headers Content is tailored and limited to specific course sections.		✔	✔	✔
Dashboardsfeatured Create dynamic pages with highly adaptable layouts.
Create unlimited dashboards Create and manage an unlimited amount of dashboards through an intuitive dashboard management interface.		✔	✔	✔
Integration Dashboards can be linked from any block region or integrated into the navigation.		✔	✔	✔
Course context Create dynamic course previews or overviews with metadata.		✔	✔	✔
Add to course navigation Dashboard with a course-specific context seamlessly integrated into the course navigation.		✔	✔	✔
Customize course listings Prevent users from accessing Moodle's course listing page.		✔	✔	✔
Access restriction Restrict access to all logged-in users, specific cohorts, role-specific or even the public as a landing page.		✔	✔	✔
Data sourcesfeatured A powerful query builder displaying tailored information from various data sources – without writing SQL queries.
Users Full control over which user details are displayed.	✔	✔	✔	✔
Video Time stats Overview of all Video Time activities within the LMS – Requires Video Time Pro.	✔	✔	✔	✔
Video Time sessions Providing insights into video consumption patterns – Requires Video Time Pro.	✔	✔	✔	✔
Courses Curating tailored course lists.		✔	✔	✔
Course categories Providing overviews or figures related to categories.		✔	✔	✔
Course certificates Generate visually appealing walls of certificates – Requires Workplace course certificates (free plugin).			✔	✔
Badges Creating detailed badge walls.			✔	✔
Course completions Tracking completion of critical courses for compliance dashboards.			✔	✔
Site logs Create a news feed highlighting recent actions.			✔	✔
Dashboards Present all available dashboards to users for easy access and navigation.			✔	✔
Activities Create detailed overviews of activities used in specific courses or categories.			✔	✔
Programs Create an intuitive interface for students to explore and select programs – Requires programs (free plugin).			✔	✔
Calendar eventsnew Show upcoming events in a customized layout.			✔	✔
Activity completionnew Analyze and even override activity completion statuses without accessing courses.				✔
Query layoutsfeatured Each layout offers plenty of configuration options to craft a unique data visualization – without any coding.
Table The table layout presents data in a structured format that is easily filterable and sortable.	✔	✔	✔	✔
Grid Presents data in a visually appealing grid format, offering extensive customization options.		✔	✔	✔
Slider Showcase highlights and create eye-catching sliders.		✔	✔	✔
Masonry Characterized by a responsive design, as the content blocks adapt to the available vertical space.		✔	✔	✔
Accordion Prioritize essential information while keeping the rest readily accessible.		✔	✔	✔
Accordion with tables Present data in tables grouped within accordion headings.		✔	✔	✔
One figure with label Minimalist layout to spotlight a single figure as an information status.		✔	✔	✔
One figure / other figure Minimalist illustration of comparisons or provision of context to numerical data.		✔	✔	✔
Timeline Ideal for visualizing events over time, particularly when paired with the site logs data source.		✔	✔	✔
Widgets Ready-to-use widgets, meticulously crafted to showcase targeted information for defined use cases.
My learning Showcases all courses in which the current user is enrolled but hasn't completed yet.	✔	✔	✔	✔
My contacts Visually presenting the contacts from the user's address book.	✔	✔	✔	✔
My groups Bringing course group management right to the user's fingertips.	✔	✔	✔	✔
Skill progress Essential tool for both gamification enthusiasts and skill assessors alike – Requires Skills Premium.	✔	✔	✔	✔
Skill level visuals Discovering skill progression visually and exploring skill levels through images – Requires Skills Premium.	✔	✔	✔	✔
Course completions Visualize course progress with progress donuts.			✔	✔
Course enrollments Elegant accordion layout with a dynamic color scheme indicating completed sections and activities.			✔	✔
My profile Designed to showcase user-related KPIs.			✔	✔
Competency graph Radar graph, designed to encapsulate aggregated insights into competency frameworks.			✔	✔
Learning pathsimproved Showcases completed and pending courses for each user in a visually appealing path. – Free Design Packages available				✔
Developer Empowering developers to craft custom data sources and layouts.
Custom data sources Creating SQL queries to craft bespoke data sources.				✔
Custom layouts The Mustache template serves as the framework for defining the layout structure.				✔
Integration with Dash Block Tailor-made data sources and layouts seamlessly integrate with Moodle's Block Dash feature.				✔

Dash

Basic

Download FREE!

Plus

Pro

Premium

Full list of features