Hello!
Everything was working very well and out of nowhere, without making any changes, I was no longer able to sort clients by ID in the backend.
I can't find any errors in the log files.
Has it happened to you? How did they solve it?
Magento ver. 2.2.11
Is your php version upgraded?
or try running by indexer command.
php bin/magento indexer:reindex
or try to follow below article, it seems related to you:
https://magento.stackexchange.com/questions/270015/magento-2-3-1-customer-grid-sorting-issue
Hi @mvp_admin
If you are using ui component to design admin grid , please check & compare your code with below exmaple:
<columns name="spinner_columns"> <selectionsColumn name="ids"> <argument name="data" xsi:type="array"> <item name="config" xsi:type="array"> <item name="resizeEnabled" xsi:type="boolean">false</item> <item name="resizeDefaultWidth" xsi:type="string">55</item> <item name="indexField" xsi:type="string">entity_id</item> </item> </argument> </selectionsColumn> <column name="entity_id"> <argument name="data" xsi:type="array"> <item name="config" xsi:type="array"> <item name="filter" xsi:type="string">textRange</item> <item name="sorting" xsi:type="string">asc</item> <item name="label" xsi:type="string" translate="true">ID</item> </item> </argument> </column> </columns>
or you can take reference from below link:
https://webkul.com/blog/how-to-create-a-grid-using-ui-component/
You will find example of ui component xml "webkul_emp_data.xml" file.
It may help you to resolve issue.
If issue resolve, please click on 'Kudos' & Accept as Solution!