## 1.0.99
*(2026-11-02)*

#### Fixed
* Fixed report hours and dates being one hour off for orders placed on the other side of a daylight-saving change: an order from summer showed an hour early or late in **Sales by Hour** after the clocks changed, and an order placed in the last hour before midnight could be counted on the wrong day. Reports now use the time zone offset of each order's own date. This needs the MySQL time zone tables; where they are not loaded, reports keep using the current offset as before and the module writes a note to `var/log/mirasvit/reports.log` explaining how to load them.
* Fixed reports running an hour behind in half-hour time zones west of UTC, such as Newfoundland (UTC-03:30), on servers without the MySQL time zone tables.

---

## 1.0.98
*(2026-10-26)*

#### Improvements
* Works with Mirasvit Core 2.0 — the module can now be installed alongside the new Core 2.0.x packages as well as Core 1.7.15 and later.
* Reports with dropdown-type columns (such as status or payment method) render a little faster: the list of possible values is now prepared once per column instead of once for every row.
* ⚠️ The unused `isFilterOnly()` method was removed from `Mirasvit\ReportApi\Api\Config\ColumnInterface` and its `Column` implementation. It could only throw an error, and no Mirasvit module calls it; custom code that implements or calls it must drop that method.

#### Fixed
* Fixed report filters for columns whose list of values is grouped under headings. The heading itself showed up in the filter list as a choice you could tick, even though it matches nothing in the report. The headings are now left out and only the actual values under them are listed and selectable. Options without a usable value are also skipped.

---

## 1.0.97
*(2026-09-29)*

#### Features
* Numeric report columns can now use the Max and Min aggregators. A numeric column pulled from a related table with several rows per report row (for example, order items under an order) can show its largest or smallest value instead of an arbitrary row. Requires mirasvit/module-report 1.4.77 or later, which Composer updates together with this release.

#### Improvements
* Reports load faster. When the first page already holds every row of the report, the report query is no longer run a second time just to count the rows.
* A custom report column defined with an expression but no source field now fails with a clear message naming the column, instead of a generic "field does not exist" error.

#### Fixed
* Fixed graphs and grouped reports coming out in a jumbled order on MySQL. When a report or dashboard graph was grouped by a dimension and no sort order was chosen, rows came back in whatever order the database returned them, so the daily revenue graph in Grand Total Summary plotted its dates out of sequence. MariaDB happened to return them in order, so the problem only showed up on MySQL. Such reports are now sorted by their grouping columns in ascending order by default. A sort order you set yourself is still used exactly as before.

---

## 1.0.96
*(2026-09-18)*

#### Improvements
* Reports grouped by hour, day, week, month or quarter now use standard PHP date handling to fill in periods that have no data, instead of a date helper from Mirasvit Core — this keeps such reports working with the new, split Core packages. An unexpected value in a date-range filter is now skipped instead of breaking the report.

#### Fixed
* **A column taken from a related table could show data from the wrong record** — When a column had to reach its data through a chain of table relationships, the report always took the shortest chain, even when that chain ran through a shared parent record and therefore matched many rows. For example, an "Order #" column on an RMA report could show an arbitrary order of that customer instead of the order the RMA was created for. Chains that lead to exactly one matching record are now preferred over shorter chains that fan out, so a related column shows the record it actually belongs to. Any column that resolved before still resolves.

---

## 1.0.95
*(2026-08-25)*

#### Improvements
* A Store filter that still points at a website you have since deleted no longer breaks the report — it simply matches no rows.

#### Fixed
* **A "Website: …" choice in the Store filter lost its checkmark after reload** — On the dashboard and in reports, picking a whole website in the Store filter worked for the current view, but once the page was reloaded the entry showed up unchecked and could be added a second time. The website choice now stays selected and keeps filtering by every store view it covers.
* Restored the full release history in this file — the 1.0.94 release accidentally wiped every earlier entry.

---

## 1.0.94
*(2026-08-04)*

#### Fixed
* Large grouped reports now export to CSV and XML faster.

---

## 1.0.93
*(2026-06-23)*

#### Fixed
* **Incorrect or missing grand totals in reports grouped by two or more dimensions** — When a report was grouped by more than one dimension, the totals row could either hide a valid total (for example, a revenue column grouped by Customer and Order Status showed no grand total) or display an inflated, double-counted total (for example, a base-table column shown under a dimension such as SKU or Category that produces multiple rows per order). The totals row now shows the correct grand total whenever it can be trusted, and is left blank only for dimensions that genuinely multiply the underlying rows, so an over-counted figure is never displayed.

---

## 1.0.92
*(2026-06-15)*

#### Fixed
* **Reports and dashboard widgets failing with a server error on PHP 8.4 and newer** — When a report or dashboard widget grouped rows by a column that was empty for some of those rows, the request returned an HTTP 500 error on PHP 8.4+ (for example, a dashboard orders widget grouped by order number when some orders had no number yet). Such rows are now grouped together under an empty value and the report loads correctly.

---

## 1.0.92-beta1
*(2026-05-28)*

#### Fixed
* **Slow Report Builder admin first-open on a cold cache (heavy schema-serialization writes)** — When the Report Builder admin was opened with a cold cache, `TableService` was serializing the accumulated DB-schema map under one monolithic cache id on every table describe, producing `O(K²)` cache write traffic that grew noticeably on installs with many tables. The cache layout has been changed to shard one entry per `(method, table)` key, so each describe writes only its own slice (`O(K)`). Cache tag/pool is unchanged — `cache:clean` and `cache:flush` continue to drop both old and new layouts together.

---

## 1.0.91
*(2026-04-23)*

#### Fixed
* Restored PHP 7.3 compatibility

---

## 1.0.90
*(2026-04-20)*

#### Fixed
* Fixed additional filters on aggregated date columns (such as minimum or maximum date) behaving incorrectly — "days ago" numeric filters are now applied only to raw date columns, not to aggregated values
* Fixed totals row returning an empty result when a filtered report matches no rows — numeric columns now show `0` and other columns show an empty value
* Fixed error in comparison mode when the report has no dimension columns

---

## 1.0.89
*(2026-03-26)*

#### Fixed
* Fixed the issue with applying filters that have multiple values (REST API)

---

## 1.0.88
*(2026-03-20)*

#### Fixed
* Fixed dashboard single-value widgets with comparison disappearing due to incorrect filter group assignment

---

## 1.0.87
*(2026-03-18)*

#### Fixed
* Fixed REST API requests producing incorrect results when filters had invalid or unexpected group values

---

## 1.0.86
*(2026-03-03)*

#### Fixed
* Fixed unnecessary table joins being added when a non-default sort order is applied to a report

---

## 1.0.85
*(2026-02-26)*

#### Features
* **REST API support** — reports can now be queried via Magento REST API with typed filter and sort order parameters
* ⚠️ `RequestFilterInterface` and `RequestSortOrderInterface` replaced by new `FilterInterface` and `SortOrderInterface` under `Api\Processor`
* ⚠️ `RequestInterface` setters removed; `ResponseInterface::toArray()` and `ResponseItemInterface::toArray()` removed
* ⚠️ Requires `mirasvit/module-report` >= 1.4.59

---

## 1.0.84
*(2025-12-22)*

#### Fixed
* Fixed incorrect filtering of reports using CTE/temporary tables when both aggregated and non-aggregated filter fields are present

---

## 1.0.83
*(2025-12-22)*

#### Fixed
* Fixed incorrect aggregation results (sums, counts, averages) in reports that use CTE or temporary tables

---

## 1.0.82
*(2025-12-10)*

#### Improvements
* Currency in reports now reflects the filtered store's currency when a single store is selected, instead of always showing the global default
* ⚠️ `StoreResolver` rewritten — now resolves base currency code instead of store ID; added `store_expr` attribute to report XML schema

#### Fixed
* Fixed CTE/temporary table filters being applied incorrectly, causing wrong report data
* Fixed incorrect currency conversion for money-type columns when filtered by a single store

---

## 1.0.81
*(2025-07-17)*

#### Fixed
* Fixed doubled/multiplied values in reports when CTE mode is enabled, caused by the main query re-aggregating already-aggregated CTE columns

---

## 1.0.80
*(2025-06-26)*

#### Features
* **CTE (Common Table Expression) mode** — optional alternative to temporary tables for building complex reports, enabled via `Stores > Configuration > Mirasvit > Reports > Advanced > Use CTE`. Can improve query performance and compatibility with read-only database replicas

---

## 1.0.79
*(2025-06-24)*

#### Fixed
* Fixed comparison data in dashboard chart widgets showing incorrect values for some date aggregation types

---

## 1.0.78
*(2025-05-06)*

#### Features
* **Days-ago date filters** — internal filters on date columns now accept integer values as "days from today" (e.g., filter to orders from the last 30 days)

#### Improvements
* Table name prefixes are now correctly applied inside column expressions that contain sub-queries, fixing errors on installations with a table prefix

---

## 1.0.77
*(2025-05-05)*

#### Fixed
* Fixed incorrect comparison data for some aggregation types (quarter, hour) in dashboard charts
* Fixed database error caused by incorrect quoting of GROUP BY fields

---

## 1.0.76
*(2025-04-07)*

#### Improvements
* Week-based reports now respect the store's "First Day of Week" setting (Monday vs Sunday start)

#### Fixed
* Fixed multidimensional reports where data from the previous year could overwrite current year values in weekly/monthly views

---

## 1.0.75
*(2025-03-26)*

#### Fixed
* Fixed filtering not working correctly on concatenated columns of type "select"

---

## 1.0.74
*(2025-03-11)*

#### Fixed
* Fixed incorrect currency conversion in store-specific reports

---

## 1.0.73
*(2024-10-29)*

#### Fixed
* Fixed incorrect totals row in RMA report grouped by attribute

---

## 1.0.72
*(2024-10-21)*

#### Fixed
* Fixed "Undefined variable" error on reports page (regression from 1.0.71)

---

## 1.0.71
*(2024-10-17)*

#### Fixed
* Fixed error on reports page when the report is based on a database table without a primary key — totals are now calculated using a fallback method

---

## 1.0.70
*(2024-09-27)*

#### Fixed
* Fixed incorrect totals for columns using the AVG aggregator — totals are now properly weighted by row count

---

## 1.0.69
*(2024-07-30)*

#### Improvements
* CONCAT aggregation now returns only unique values, preventing duplicated entries in concatenated columns

---

## 1.0.68
*(2024-06-12)*

#### Features
* **Request logging toggle** — ability to enable or disable logging of report query requests for debugging purposes

---

## 1.0.67
*(2024-04-19)*

#### Fixed
* Fixed PHP warning when grouping report data ("Method expects parameter of type array|string, received Zend_Db_Expr")

---

## 1.0.66
*(2024-04-18)*

#### Fixed
* Fixed dashboard chart comparison data showing incomplete or missing values for the previous period — gaps in the date series are now filled correctly
* Fixed incorrect data in multidimensional reports caused by wrong base table selection for temporary tables

---

## 1.0.65
*(2024-03-06)*

#### Fixed
* Fixed incorrect totals when a report includes an aggregated column from a table different from the report's base table

---

## 1.0.64
*(2023-12-04)*

#### Features
* **Group by dimensions toggle** — new configuration option to enable or disable automatic grouping of report data by dimension columns

---

## 1.0.63
*(2023-09-18)*

#### Fixed
* Fixed internal filters not being applied correctly to report queries

---

## 1.0.62
*(2023-08-22)*

#### Fixed
* Fixed "Illegal offset type" error on reports that include custom EAV attributes (e.g., `em_shipping_policy`)

---

## 1.0.61
*(2023-08-18)*

#### Fixed
* Fixed primary toolbar filters not working correctly in some reports — filter detection now uses the report's declared primary and internal filters instead of column name heuristics

---

## 1.0.60
*(2023-06-14)*

#### Fixed
* Fixed the Product Performance report returning incorrect results

---

## 1.0.59
*(2023-06-02)*

#### Fixed
* Fixed reports not returning results when filter values include zero (e.g., filtering "from 0 to 0")

---

## 1.0.58
*(2023-02-06)*

#### Fixed
* Fixed "Insert value list does not match column list" error when using `sales_order_item|item_id` as report dimension

---

## 1.0.57
*(2023-01-23)*

#### Improvements
* ⚠️ Magento 2.4.6 compatibility — replaced deprecated `Zend_Json` with Magento's native JSON serializer across all classes that handle serialization

---

## 1.0.56
*(2022-12-28)*

#### Fixed
* Fixed incorrect data in report columns related to configurable product attributes

---

## 1.0.55
*(2022-10-28)*

#### Fixed
* Fixed reports not using the correct default currency

---

## 1.0.54
*(2022-06-27)*

#### Fixed
* Fixed report configuration files being loaded in unpredictable order, which could cause config overrides to not take effect

---

## 1.0.53
*(2022-06-15)*

#### Fixed
* Fixed "Invalid Document Element 'pk': This element is not expected" error during report configuration validation

---

## 1.0.52
*(2022-06-03)*

#### Fixed
* Fixed errors when applying tax-related filters to reports

---

## 1.0.51
*(2022-05-10)*

#### Improvements
* ⚠️ Updated internal query building to use Magento's current database API, replacing deprecated methods

---

## 1.0.49
*(2022-01-26)*

#### Fixed
* Fixed PHP 8.1 compatibility issues
* Fixed "auto_increment field" error when creating temporary report tables

---

## 1.0.48
*(2022-01-21)*

#### Fixed
* Fixed PHP 8.1 compatibility issue in report collection handler

---

## 1.0.47
*(2022-01-13)*

#### Improvements
* Improved report query performance by optimizing the data collection process

---

## 1.0.46
*(2021-10-18)*

#### Fixed
* Fixed incorrect currency display when the store filter includes multiple stores

---

## 1.0.45
*(2021-08-26)*

#### Fixed
* Fixed MySQL error when applying a filter on the entity ID (primary key) column

---

## 1.0.44
*(2021-06-24)*

#### Fixed
* Fixed reports showing frontend attribute option labels instead of admin area labels

---

## 1.0.43
*(2021-03-10)*

#### Fixed
* Fixed filtering not working on multiselect-type attributes in reports

---

## 1.0.42
*(2021-02-18)*

#### Fixed
* Fixed the WEEK date aggregator producing incorrect week boundaries near year transitions
* Fixed errors when using custom customer attributes in reports on Magento Enterprise Edition
* Fixed report configuration validation error when field names contain numbers

---

## 1.0.41
*(2020-10-07)*

#### Improvements
* Added internationalization support with translatable strings for report UI elements

---

## 1.0.40
*(2020-08-31)*

#### Fixed
* Fixed compatibility with Magento Enterprise Edition split database architecture

---

## 1.0.39
*(2020-07-29)*

#### Improvements
* Magento 2.4 compatibility

#### Fixed
* Fixed incorrect currency conversion in reports filtered by website

---

## 1.0.38
*(2020-06-17)*

#### Fixed
* Fixed error when saving a custom report without selecting a dimension ("Undefined offset: 0")
* Fixed the WEEK date aggregator producing incorrect results near end of year

---

## 1.0.37
*(2020-04-14)*

#### Fixed
* Fixed empty table widgets in dashboard when a custom date range is selected (regression from 1.0.36)

---

## 1.0.36
*(2020-04-08)*

#### Fixed
* Fixed reports displaying values in the wrong default currency

---

## 1.0.35
*(2020-03-20)*

#### Fixed
* Fixed "Type Error occurred when creating object: Mirasvit\ReportApi\Config\Loader\Data" error on dashboard and reports pages

---

## 1.0.34
*(2020-03-02)*

#### Fixed
* Fixed error caused by excessively long temporary table names (e.g., with customer segment reports)
* Fixed "Call to undefined method toOptionArray()" error with non-existent attributes

---

## 1.0.33
*(2020-01-15)*

#### Features
* **Store currency display** — reports now display values in the store's default currency instead of the global base currency

---

## 1.0.32
*(2020-01-10)*

#### Improvements
* Improved report query performance through optimized column resolution and select building

---

## 1.0.31
*(2020-01-08)*

#### Improvements
* Improved report query performance

---

## 1.0.30
*(2019-11-22)*

#### Fixed
* Fixed reports not displaying negative values

---

## 1.0.29
*(2019-11-06)*

#### Fixed
* Fixed incorrect table join on Magento Enterprise Edition causing wrong report data

---

## 1.0.27
*(2019-10-25)*

#### Fixed
* Fixed incorrect pagination in reports caused by timezone differences in page size calculation
* Fixed compatibility with Amasty Gift Card extension

---

## 1.0.26
*(2019-08-30)*

#### Fixed
* Fixed potential issue with loading attribute options for select-type columns

---

## 1.0.25
*(2019-08-29)*

#### Improvements
* Cached attribute options to prevent slow initial loading of reports with many select-type columns

#### Fixed
* Fixed typo in composer.json

---

## 1.0.24
*(2019-08-08)*

#### Improvements
* Code quality improvements for Magento Extension Quality Program compliance

---

## 1.0.23
*(2019-04-11)*

#### Improvements
* ⚠️ Changed package type from `magento2-module` to `magento2-library`

---

## 1.0.22
*(2019-01-25)*

#### Fixed
* Fixed incorrect join strategy for sales order item table, causing wrong results in order item reports

---

## 1.0.21
*(2019-01-18)*

#### Fixed
* Fixed incorrect results in the "Sales by Attribute" report

---

## 1.0.20
*(2019-01-02)*

#### Fixed
* Fixed report sorting not being applied correctly

---

## 1.0.19
*(2018-12-22)*

#### Features
* **Multi-dimension reports** — reports can now use multiple dimension columns for more detailed breakdowns

---

## 1.0.18
*(2018-12-17)*

#### Improvements
* Enhanced relations API for more flexible table joining in report configurations

---

## 1.0.17
*(2018-12-11)*

#### Improvements
* Improved response interface for report data output

#### Fixed
* Fixed errors related to temporary table creation in certain report configurations

---

## 1.0.16
*(2018-12-05)*

#### Fixed
* Fixed query timeout when loading reports with many columns

---

## 1.0.15
*(2018-12-04)*

#### Fixed
* Fixed API schema interface returning incorrect type

---

## 1.0.14
*(2018-11-29)*

#### Features
* **Column service** — new dedicated service for column resolution and label generation
* Magento 2.3 compatibility

#### Improvements
* ⚠️ Major internal refactoring of collection handling, response building, and select service — custom report integrations may need updates
* Column names now use the field name as the default label when no explicit label is configured

---

## 1.0.12
*(2018-09-28)*

#### Features
* **Select pills** — ability to provide patches (plugins) for temporary table creation, enabling custom data transformations during report building

---

## 1.0.11
*(2018-09-26)*

#### Features
* **Column groups and labels** — columns and tables can now be organized into named groups with custom labels in report configuration

---

## 1.0.10
*(2018-09-25)*

#### Features
* **Serialized column type** — new column type for displaying data stored in serialized format

---

## 1.0.9
*(2018-09-21)*

#### Fixed
* Fixed inability to create custom reports when tables have deep relation chains

---

## 1.0.8
*(2018-09-05)*

#### Fixed
* Fixed timezone not being applied in some reports, causing incorrect date-based values
* Fixed customer EAV attributes not displaying correctly in reports
* Fixed reports failing to load when an attribute has a missing source model

---

## 1.0.7
*(2018-08-17)*

#### Fixed
* Fixed "Sales by Day of Week" report assigning wrong weekday names to dates

---

## 1.0.6
*(2018-08-03)*

#### Improvements
* QTY-type columns can now be used with the COUNT aggregator

---

## 1.0.5
*(2018-08-03)*

#### Improvements
* String-type columns can now be used with the COUNT aggregator

---

## 1.0.4
*(2018-07-30)*

#### Fixed
* Fixed COUNT aggregator counting duplicate values — now counts only distinct values

---

## 1.0.3
*(2018-07-30)*

#### Features
* **Filter-only columns** — API method to mark columns as available only for filtering, not for display in report results

---

## 1.0.2
*(2018-07-24)*

#### Fixed
* Fixed filters not being applied in some report configurations

---

## 1.0.1
*(2018-07-23)*

#### Improvements
* Report column names are now translatable via Magento's i18n system

---
