Sorting attributes with numerical codes

[marcin-dorosiewicz]

Hi,

🐛 I'm reporting a Bug 🐛

Tested on the latest version: 7.0.46 but also earlier versions, there is an error for attributes whose code is numeric. The error relates to the sorting on the product grids.

The way to reproduce this error:

1. Add an attribute with a numeric code to any group with the option to display on the grid.

Code (required): 385
Type: Simple select
Attribute group (required): General
Usable in grid: Yes

2. Add a column with numeric code to the product grid

3. the page cannot load.

Log message:

[2024-01-09T06:40:40.404982+00:00] request.CRITICAL: Uncaught PHP Exception LogicException: "Could not found column(s) "385" for sorting" at /srv/pim/vendor/akeneo/pim-community-dev/src/Oro/Bundle/PimDataGridBundle/Extension/Sorter/SorterExtension.php line 100 {"exception":"[object] (LogicException(code: 0): Could not found column(s) \"385\" for sorting at /srv/pim/vendor/akeneo/pim-community-dev/src/Oro/Bundle/PimDataGridBundle/Extension/Sorter/SorterExtension.php:100)"} []

The way to solve broken product grid

Relogging (The column is not added but we can display the grid)

System info file:

akeneo-pim-system-info_2024-01-09_06 41.txt