inventory [Issue] disabled sorting column allocated

[Issue] disabled sorting column allocated_sources in sales order grid

Open m2-assistant[bot] opened this issue 4 years ago • 4 comments

trafficstars

This issue is automatically created based on existing pull request: magento/inventory#3205: disabled sorting column allocated_sources in sales order grid

Description (*)

if you to want sort order grid by allocated_sources asc or desc then you see magento popup error and in error log writing message "[2020-10-01 15:40:45] main.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'allocated_sources' in 'order clause', query was: SELECT main_table., braintree_transaction_details.transaction_source FROM sales_order_grid AS main_table LEFT JOIN braintree_transaction_details ON braintree_transaction_details.order_id = main_table.entity_id ORDER BY allocated_sources ASC LIMIT 20 {"exception":"[object] (Zend_Db_Statement_Exception(code: 42): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'allocated_sources' in 'order clause', query was: SELECT main_table., braintree_transaction_details.transaction_source FROM sales_order_grid AS main_table LEFT JOIN braintree_transaction_details ON braintree_transaction_details.order_id = main_table.entity_id ORDER BY allocated_sources ASC LIMIT 20 at vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'allocated_sources' in 'order clause' at /vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} [] " If this field is marked false I think this field is marked should be false

Manual testing scenarios (*)

Field Allocated sources not be sorted

Questions or comments

Contribution checklist (*)

[ ] Pull request has a meaningful description of its purpose
[ ] All commits are accompanied by meaningful commit messages
[ ] All new or changed code is covered with unit/integration tests (if applicable)
[ ] All automated tests passed successfully (all builds are green)