Skip to main content

General settings

All configurations of the Advanced Reports extension are located at Stores -> Configuration -> Mirasvit Extensions -> Advanced Reports.

General​

General contains basic settings:

  • Order Status: this setting defines which order statuses will be pre-selected as a filter for all reports and dashboard blocks.

  • Group Report Data by Dimensions: whether the extension will group data in multidemensional reports to avoid displaying duplicated data for dimension columns.

  • Format data in CSV files: if disabled, the extension will put unformatted (raw) data for numeric columns in CSV files.

Advanced settings​

This section has only one setting: Use CTEs instead of temporary tables. Some reports use temporary tables to handle complex data processing. However, with large datasets, this can cause table locking issues. Enabling this option switches from using temporary tables to Common Table Expressions (CTEs), which helps avoid such locking problems.

Note

Use this option only if your database server is running MySQL 8.0 or higher, or MariaDB 10.2 or higher, as earlier versions do not support CTEs.

Debug​

This section has only one setting: Enable Logging Reports Requests. This setting defines if the extension will log reports requests details into the system.log file.