About
The Join tables section allows you to connect the main table with other Moodle database tables to create a more comprehensive data source. By establishing these relationships, you can include fields from different parts of the database within a single data source.
To access these settings, navigate to Site administration > Plugins > Local plugins > Dash Addons > Manage data sources and select Create custom data source or Edit.
Available settings
Enable joins – Only when enabled, the data source retrieves data from the configured joins.
Select join table – Choose the additional table you wish to link with your main table to enrich the data source.
Table alias – Assign a short, unique keyword for the selected table, such as "cc" for the course categories table.
Enter condition query to join Specify the logic used to link the selected table with other tables, utilizing your defined alias keywords for accurate linkage. For example, you might link a table to the main table using a query like
mnt.category = cc.id.Delete – Remove the specific join configuration from the data source.
Add 1 join table to form – Add an additional table join configuration to the settings.