| Moodle APIs 4.3
    Moodle 4.3.6 (Build: 20240812) | 
Class datasource. More...
| Public Member Functions | |
| add_attributes (array $attributes) | |
| Add report attributes (data-, class, etc.) that will be included in HTML when report is displayed. | |
| add_base_condition_simple (string $fieldname, $fieldvalue) | |
| Define simple "field = value" clause to apply to the report query. | |
| add_base_condition_sql (string $where, array $params=[]) | |
| Define more complex/non-empty clause to apply to the report query. | |
| add_default_columns () | |
| Add default datasource columns to the report. | |
| add_default_conditions () | |
| Add default datasource conditions to the report. | |
| add_default_filters () | |
| Add default datasource filters to the report. | |
| get_active_columns () | |
| Override parent method, returning only those columns specifically added to the custom report (rather than all that are available) | |
| get_active_columns_by_alias () | |
| Return all active report columns, keyed by their alias (only active columns in a report would have a valid alias/index) | |
| get_active_conditions () | |
| Override parent method, returning only those conditions specifically added to the custom report (rather than all that are available) | |
| get_active_filters () | |
| Override parent method, returning only those filters specifically added to the custom report (rather than all that are available) | |
| get_applied_filter_count () | |
| Return the number of filter instances that are being applied based on the report's filter values (i.e. | |
| get_attributes () | |
| Returns the report HTML attributes. | |
| get_base_condition () | |
| Return base select/params for the report query. | |
| get_column (string $uniqueidentifier) | |
| Return report column by unique identifier. | |
| get_columns () | |
| Return all available report columns. | |
| get_condition (string $uniqueidentifier) | |
| Return report condition by unique identifier. | |
| get_condition_instances () | |
| Return all active report condition instances. | |
| get_condition_values () | |
| Get the condition values of the report. | |
| get_conditions () | |
| Return all available report conditions. | |
| get_context () | |
| Returns the report context. | |
| get_default_column_sorting () | |
| Return the default column sorting that will be set for the report upon creation, by {. | |
| get_default_columns () | |
| Return the default columns that will be added to the report upon creation, by {. | |
| get_default_condition_values () | |
| Return the default condition values that will be added to the report once is created. | |
| get_default_conditions () | |
| Return the conditions that will be added to the report once is created. | |
| get_default_filters () | |
| Return the filters that will be added to the report once is created. | |
| get_default_no_results_notice () | |
| Get the default lang string for the notice used when no results are found. | |
| get_default_per_page () | |
| Default 'per page' size. | |
| get_downloadfilename () | |
| Return the downloadable report filename. | |
| get_entity_title (string $name) | |
| Returns title of given report entity. | |
| get_filter (string $uniqueidentifier) | |
| Return report filter by unique identifier. | |
| get_filter_instances () | |
| Return all active report filter instances. | |
| get_filter_values () | |
| Get the filter values of the report. | |
| get_filters () | |
| Return all available report filters. | |
| get_joins () | |
| Return report JOIN clauses. | |
| get_main_table () | |
| Get the main table name. | |
| get_main_table_alias () | |
| Get the alias for the main table. | |
| get_report_persistent () | |
| Returns persistent class used when initialising this report. | |
| get_settings_values () | |
| Get the settings values of the report. | |
| is_downloadable () | |
| Get if the report can be downloaded. | |
| set_condition_values (array $values) | |
| Set the condition values of the report. | |
| set_default_no_results_notice (?lang_string $notice) | |
| Set the default lang string for the notice used when no results are found. | |
| set_default_per_page (int $defaultperpage) | |
| Set the default 'per page' size. | |
| set_downloadable (bool $downloadable, ?string $downloadfilename=null) | |
| Set if the report can be downloaded. | |
| set_filter_values (array $values) | |
| Set the filter values of the report. | |
| set_main_table (string $tablename, string $tablealias='') | |
| Set the main table and alias for the SQL query. | |
| set_settings_values (array $values) | |
| Set the settings values of the report. | |
| Static Public Member Functions | |
| static | get_name () | 
| Return user friendly name of the report. | |
| static | is_available () | 
| Get the report availability. | |
| static | report_elements_modified (int $reportid) | 
| Indicate that report elements have been modified, e.g. | |
| Public Attributes | |
| int const | DEFAULT_PAGESIZE = 30 | 
| Default paging limit. | |
| int const | TYPE_CUSTOM_REPORT = 0 | 
| Custom report type value. | |
| int const | TYPE_SYSTEM_REPORT = 1 | 
| System report type value. | |
| Protected Member Functions | |
| add_all_from_entities () | |
| Adds all columns/filters/conditions from all the entities added to the report at once. | |
| add_all_from_entity (string $entityname) | |
| Adds all columns/filters/conditions from the given entity to the report at once. | |
| add_column (column $column) | |
| Adds a column to the report. | |
| add_column_from_entity (string $uniqueidentifier) | |
| Add given column to the report from an entity. | |
| add_columns_from_entities (array $columns) | |
| Add given columns to the report from one or more entities. | |
| add_columns_from_entity (string $entityname, array $include=[], array $exclude=[]) | |
| Add columns from the given entity name to be available to use in a custom report. | |
| add_condition (filter $condition) | |
| Adds a condition to the report. | |
| add_condition_from_entity (string $uniqueidentifier) | |
| Add given condition to the report from an entity. | |
| add_conditions_from_entities (array $conditions) | |
| Add given conditions to the report from one or more entities. | |
| add_conditions_from_entity (string $entityname, array $include=[], array $exclude=[]) | |
| Add conditions from the given entity name to be available to use in a custom report. | |
| add_entity (entity_base $entity) | |
| Adds given entity, along with it's columns and filters, to the report. | |
| add_filter (filter $filter) | |
| Adds a filter to the report. | |
| add_filter_from_entity (string $uniqueidentifier) | |
| Add given filter to the report from an entity. | |
| add_filters_from_entities (array $filters) | |
| Add given filters to the report from one or more entities. | |
| add_filters_from_entity (string $entityname, array $include=[], array $exclude=[]) | |
| Add filters from the given entity name to be available to use in a custom report. | |
| add_join (string $join, array $params=[], bool $validateparams=true) | |
| Adds report JOIN clause that is always added. | |
| annotate_entity (string $name, lang_string $title) | |
| Define a new entity for the report. | |
| get_entities () | |
| Returns the list of all the entities added to the report. | |
| get_entity (string $name) | |
| Returns the entity added to the report from the given entity name. | |
| initialise () | |
| Initialise report. | |
| validate () | |
| Perform some basic validation about expected class properties. | |
Class datasource.
| 
 | finalprotected | 
Adds all columns/filters/conditions from the given entity to the report at once.
| string | $entityname | 
| 
 | inherited | 
Add report attributes (data-, class, etc.) that will be included in HTML when report is displayed.
| array | $attributes | 
| self | 
| 
 | finalinherited | 
Define simple "field = value" clause to apply to the report query.
| string | $fieldname | |
| mixed | $fieldvalue | 
| 
 | finalinherited | 
Define more complex/non-empty clause to apply to the report query.
| string | $where | |
| array | $params | Note that the param names should be generated by { | 
| 
 | finalprotectedinherited | 
Adds a column to the report.
| column | $column | 
| column | 
| coding_exception | 
| 
 | finalprotectedinherited | 
Add given column to the report from an entity.
The entity must have already been added to the report before calling this method
| string | $uniqueidentifier | 
| column | 
| 
 | finalprotectedinherited | 
Add given columns to the report from one or more entities.
Each entity must have already been added to the report before calling this method
| string[] | $columns | Unique identifier of each entity column | 
| 
 | finalprotected | 
Add columns from the given entity name to be available to use in a custom report.
| string | $entityname | |
| array | $include | Include only these columns, if omitted then include all | 
| array | $exclude | Exclude these columns, if omitted then exclude none | 
| coding_exception | If both $include and $exclude are non-empty | 
| 
 | finalprotectedinherited | 
Adds a condition to the report.
| filter | $condition | 
| filter | 
| coding_exception | 
| 
 | finalprotectedinherited | 
Add given condition to the report from an entity.
The entity must have already been added to the report before calling this method
| string | $uniqueidentifier | 
| filter | 
| 
 | finalprotectedinherited | 
Add given conditions to the report from one or more entities.
Each entity must have already been added to the report before calling this method
| string[] | $conditions | Unique identifier of each entity condition | 
| 
 | finalprotected | 
Add conditions from the given entity name to be available to use in a custom report.
| string | $entityname | |
| array | $include | Include only these conditions, if omitted then include all | 
| array | $exclude | Exclude these conditions, if omitted then exclude none | 
| coding_exception | If both $include and $exclude are non-empty | 
| core_reportbuilder\datasource::add_default_columns | ( | ) | 
Add default datasource columns to the report.
Uses column data returned by the source {
| coding_exception | If default column sorting refers to an invalid column | 
| core_reportbuilder\datasource::add_default_conditions | ( | ) | 
Add default datasource conditions to the report.
This method is optional and can be called when the report is created to add the default conditions defined in the selected datasource.
| core_reportbuilder\datasource::add_default_filters | ( | ) | 
Add default datasource filters to the report.
This method is optional and can be called when the report is created to add the default filters defined in the selected datasource.
| 
 | finalprotectedinherited | 
Adds given entity, along with it's columns and filters, to the report.
| entity_base | $entity | 
| 
 | finalprotectedinherited | 
Adds a filter to the report.
| filter | $filter | 
| filter | 
| coding_exception | 
| 
 | finalprotectedinherited | 
Add given filter to the report from an entity.
The entity must have already been added to the report before calling this method
| string | $uniqueidentifier | 
| filter | 
| 
 | finalprotectedinherited | 
Add given filters to the report from one or more entities.
Each entity must have already been added to the report before calling this method
| string[] | $filters | Unique identifier of each entity filter | 
| 
 | finalprotected | 
Add filters from the given entity name to be available to use in a custom report.
| string | $entityname | |
| array | $include | Include only these filters, if omitted then include all | 
| array | $exclude | Exclude these filters, if omitted then exclude none | 
| coding_exception | If both $include and $exclude are non-empty | 
| 
 | protectedinherited | 
Adds report JOIN clause that is always added.
| string | $join | |
| array | $params | |
| bool | $validateparams | Some queries might add non-standard params and validation could fail | 
| 
 | finalprotectedinherited | 
Define a new entity for the report.
| string | $name | |
| lang_string | $title | 
| coding_exception | 
| core_reportbuilder\datasource::get_active_columns | ( | ) | 
Override parent method, returning only those columns specifically added to the custom report (rather than all that are available)
| column[] | 
Reimplemented from core_reportbuilder\local\report\base.
| 
 | finalinherited | 
Return all active report columns, keyed by their alias (only active columns in a report would have a valid alias/index)
| column[] | 
| core_reportbuilder\datasource::get_active_conditions | ( | ) | 
Override parent method, returning only those conditions specifically added to the custom report (rather than all that are available)
| filter[] | 
Reimplemented from core_reportbuilder\local\report\base.
| core_reportbuilder\datasource::get_active_filters | ( | ) | 
Override parent method, returning only those filters specifically added to the custom report (rather than all that are available)
| filter[] | 
Reimplemented from core_reportbuilder\local\report\base.
| 
 | finalinherited | 
Return the number of filter instances that are being applied based on the report's filter values (i.e.
user has configured them from their initial "Any value" state)
| int | 
| 
 | inherited | 
Returns the report HTML attributes.
| array | 
| 
 | finalinherited | 
Return base select/params for the report query.
| array | [string $select, array $params] | 
| 
 | finalinherited | 
Return report column by unique identifier.
| string | $uniqueidentifier | 
| column|null | 
| 
 | finalinherited | 
Return all available report columns.
| column[] | 
| 
 | finalinherited | 
Return report condition by unique identifier.
| string | $uniqueidentifier | 
| filter|null | 
| 
 | finalinherited | 
Return all active report condition instances.
| filter_base[] | 
| 
 | finalinherited | 
Get the condition values of the report.
| array | 
| 
 | finalinherited | 
Return all available report conditions.
| filter[] | 
| 
 | inherited | 
Returns the report context.
| context | 
| core_reportbuilder\datasource::get_default_column_sorting | ( | ) | 
Return the default column sorting that will be set for the report upon creation, by {.
When overriding this method in child classes, column identifiers specified must refer to default columns returned from the {
| int[] | array [column identifier => SORT_ASC/SORT_DESC] | 
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_badges\reportbuilder\datasource\badges, core_badges\reportbuilder\datasource\users, core_blog\reportbuilder\datasource\blogs, core_cohort\reportbuilder\datasource\cohorts, core_comment\reportbuilder\datasource\comments, core_course\reportbuilder\datasource\categories, core_course\reportbuilder\datasource\courses, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, core_group\reportbuilder\datasource\groups, core_notes\reportbuilder\datasource\notes, core_tag\reportbuilder\datasource\tags, and core_user\reportbuilder\datasource\users.
| 
 | abstract | 
Return the default columns that will be added to the report upon creation, by {.
| string[] | 
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_badges\reportbuilder\datasource\badges, core_badges\reportbuilder\datasource\users, core_blog\reportbuilder\datasource\blogs, core_cohort\reportbuilder\datasource\cohorts, core_comment\reportbuilder\datasource\comments, core_course\reportbuilder\datasource\categories, core_course\reportbuilder\datasource\courses, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, core_group\reportbuilder\datasource\groups, core_notes\reportbuilder\datasource\notes, core_tag\reportbuilder\datasource\tags, and core_user\reportbuilder\datasource\users.
| core_reportbuilder\datasource::get_default_condition_values | ( | ) | 
Return the default condition values that will be added to the report once is created.
For any of the default conditions returned by the method {
| array | 
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, and core_user\reportbuilder\datasource\users.
| 
 | abstract | 
Return the conditions that will be added to the report once is created.
| string[] | 
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_badges\reportbuilder\datasource\badges, core_badges\reportbuilder\datasource\users, core_blog\reportbuilder\datasource\blogs, core_cohort\reportbuilder\datasource\cohorts, core_comment\reportbuilder\datasource\comments, core_course\reportbuilder\datasource\categories, core_course\reportbuilder\datasource\courses, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, core_group\reportbuilder\datasource\groups, core_notes\reportbuilder\datasource\notes, core_tag\reportbuilder\datasource\tags, and core_user\reportbuilder\datasource\users.
| 
 | abstract | 
Return the filters that will be added to the report once is created.
| string[] | 
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_badges\reportbuilder\datasource\badges, core_badges\reportbuilder\datasource\users, core_blog\reportbuilder\datasource\blogs, core_cohort\reportbuilder\datasource\cohorts, core_comment\reportbuilder\datasource\comments, core_course\reportbuilder\datasource\categories, core_course\reportbuilder\datasource\courses, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, core_group\reportbuilder\datasource\groups, core_notes\reportbuilder\datasource\notes, core_tag\reportbuilder\datasource\tags, and core_user\reportbuilder\datasource\users.
| 
 | inherited | 
Get the default lang string for the notice used when no results are found.
| lang_string|null | the lang_string instance or null if the report prefers not to use one. | 
| 
 | inherited | 
Default 'per page' size.
| int | 
| 
 | finalinherited | 
Return the downloadable report filename.
| string | 
| 
 | finalprotectedinherited | 
Returns the list of all the entities added to the report.
| entity_base[] | 
| 
 | finalprotectedinherited | 
Returns the entity added to the report from the given entity name.
| string | $name | 
| entity_base | 
| coding_exception | 
| 
 | finalinherited | 
Returns title of given report entity.
| string | $name | 
| lang_string | 
| coding_exception | 
| 
 | finalinherited | 
Return report filter by unique identifier.
| string | $uniqueidentifier | 
| filter|null | 
| 
 | finalinherited | 
Return all active report filter instances.
| filter_base[] | 
| 
 | finalinherited | 
Get the filter values of the report.
| array | 
| 
 | finalinherited | 
Return all available report filters.
| filter[] | 
| 
 | inherited | 
Return report JOIN clauses.
| array | 
| 
 | finalinherited | 
Get the main table name.
| string | 
| 
 | finalinherited | 
Get the alias for the main table.
| string | 
| 
 | staticabstractinherited | 
Return user friendly name of the report.
| string | 
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_admin\reportbuilder\local\systemreports\task_logs, core_badges\reportbuilder\datasource\badges, core_badges\reportbuilder\datasource\users, core_blog\reportbuilder\datasource\blogs, core_cohort\reportbuilder\datasource\cohorts, core_comment\reportbuilder\datasource\comments, core_course\reportbuilder\datasource\categories, core_course\reportbuilder\datasource\courses, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, core_group\reportbuilder\datasource\groups, core_notes\reportbuilder\datasource\notes, core_reportbuilder\system_report, core_tag\reportbuilder\datasource\tags, and core_user\reportbuilder\datasource\users.
| 
 | finalinherited | 
Returns persistent class used when initialising this report.
| report | 
| 
 | finalinherited | 
Get the settings values of the report.
| array | 
| 
 | abstractprotectedinherited | 
Initialise report.
Specify which columns, filters, etc should be present
To set the base query use:
Reimplemented in core_admin\reportbuilder\datasource\task_logs, core_admin\reportbuilder\local\systemreports\task_logs, core_badges\reportbuilder\datasource\badges, core_badges\reportbuilder\datasource\users, core_badges\reportbuilder\local\systemreports\badges, core_blog\reportbuilder\datasource\blogs, core_cohort\reportbuilder\datasource\cohorts, core_cohort\reportbuilder\local\systemreports\cohorts, core_comment\reportbuilder\datasource\comments, core_comment\reportbuilder\local\systemreports\comments, core_course\reportbuilder\datasource\categories, core_course\reportbuilder\datasource\courses, core_course\reportbuilder\datasource\participants, core_files\reportbuilder\datasource\files, core_group\reportbuilder\datasource\groups, core_notes\reportbuilder\datasource\notes, core_reportbuilder\local\systemreports\report_access_list, core_reportbuilder\local\systemreports\report_schedules, core_reportbuilder\local\systemreports\reports_list, core_tag\reportbuilder\datasource\tags, core_user\reportbuilder\datasource\users, gradereport_summary\local\systemreports\summary, mod_lti\reportbuilder\local\systemreports\course_external_tools_list, and report_configlog\reportbuilder\local\systemreports\config_changes.
| 
 | staticinherited | 
Get the report availability.
Sub-classes should override this method to declare themselves unavailable, for example if they require classes that aren't present due to missing plugin
| bool | 
| 
 | finalinherited | 
Get if the report can be downloaded.
| bool | 
| 
 | staticfinal | 
Indicate that report elements have been modified, e.g.
columns/filters/conditions have been added, removed or updated
| int | $reportid | 
| 
 | finalinherited | 
Set the condition values of the report.
| array | $values | 
| bool | 
| 
 | inherited | 
Set the default lang string for the notice used when no results are found.
| lang_string | null | $notice | string, or null to tell the report to omit the notice entirely. | 
| void | 
| 
 | inherited | 
Set the default 'per page' size.
| int | $defaultperpage | 
| 
 | finalinherited | 
Set if the report can be downloaded.
| bool | $downloadable | |
| string | null | $downloadfilename | If downloadable, then the name of the file (defaults to the name of the current report) | 
| 
 | finalinherited | 
Set the filter values of the report.
| array | $values | 
| bool | 
| 
 | finalinherited | 
Set the main table and alias for the SQL query.
| string | $tablename | |
| string | $tablealias | 
| 
 | finalinherited | 
Set the settings values of the report.
| array | $values | 
| bool | 
| 
 | protectedinherited | 
Perform some basic validation about expected class properties.
| coding_exception | 
Reimplemented in core_reportbuilder\system_report.