bopsstats.blogg.se - Report builder sql

REPORT BUILDER SQL GENERATOR
REPORT BUILDER SQL FULL
REPORT BUILDER SQL DOWNLOAD

Highlighted text fields: To visualise a status, for example, status fields in programs and certifications.

Hyperlinked text fields: Mainly to direct viewers directly to entries, for example, to a user profile or a program.

REPORT BUILDER SQL GENERATOR

Some text fields are preprocessed by the report generator to support additional functionality:

REPORT BUILDER SQL FULL

Text fields: For example, full name, job, or program name.

The following field types are available to be added as columns to a report: To remove a column, click on the standard delete icon. You can then rearrange the column order via the standard Move handle. The column will be added automatically as the rightmost column in the table. To add columns to the report, click on the selected field in the list on the left. You can also search for field entries to limit the number of displayed items. Each entity can be expanded or collapsed for better usability. In the left-hand side panel of the report generator, you will see all available fields for the selected report source, which have been grouped into entities.

You can reduce or rearrange the options in that list in Site administration > Plugins > Data formats > Manage data formats.

REPORT BUILDER SQL DOWNLOAD

Viewers also have the option to download the table data in various formats, namely CSV, XLSX, HTML, JSON, ODS, and PDF. Underneath the preview table, there is a Current query option that shows the underlying SQL query that is generated based on the configuration of your report: The accordion sidebar can be shown/hidden via the settings sidebar toggle. Settings sidebar (right): Lets you configure conditions, filters, sorting, and card view options.To grasp a view of what the report will look like to users, select the Preview toggle. Column headings and aggregation methods can be edited inline. Preview window (middle): Shows the data according to the current report configuration.The sidebar can be shown/hidden via the data field sidebar toggle next to the report name. Columns sidebar (left): Shows the list of available data fields grouped by entities, including a live search option.The interface of the report builder is divided into three panels: Once you have created the report, you will be redirected to the actual report builder. Course reset for individual user: Course resetting data during recertification.Users list: Users and their job assignments.Certificate issues: Issued certificates to users.Certificate templates: Available certificate templates.Course enrolments: Course details, user enrolments, and course completion.Course participants: Course completion report.Course completion from datastore: Data in Workplace datastore.Programs users allocation and completion: Program details, including users’ progress information.Certification users allocation and completion: Certification details, including users’ progress information.

Appointments: Seminars, sessions and participants.

The following report sources are available in Moodle Workplace, grouped by report plugin: When the Add default configuration option remains enabled, the report will be populated with several predefined columns, conditions, and filters. To create a new report, select the +New report button.Ī report contains two required settings: Report name (displayed whenever the report is being made available to users) and Report source (defines where the data for the report will come from). You can access the management of custom reports via Site administration > Reports > Manage custom reports, or directly via the Report builder icon in the Workplace launcher.

Filters, which have to be configured by the report creator, allow the viewer to select one or more criteria to reduce the amount of data further, for instance, by the level of progress.

Access to reports is granted via audiences, for example, all members of a selected cohort.

Applying conditions lets you decide which rows will be made available, for instance, all records from a selected department.

Configuring data fields lets you decide which columns are being made available, for example, user name, certification name, and completion status.

Based on the selected report source, a certain amount of data will be available, which can be reduced by the following mechanisms: A record source contains a predefined set of fields that are available when building a report. Workplace offers a range of report sources to simplify the usage of the report builder.