On admin in Sales Order Grid, I am getting the following error. Please guide on this:
Column not found: 1054 Unknown column 'allocated_sources' in 'order clause', query was: SELECT `main_table`.*, group_concat(sales_order_item.sku SEPARATOR ", ") AS `skus`, group_concat(sales_order_item.name SEPARATOR ",") AS `names`, `braintree_transaction_details`.`transaction_source` FROM `sales_order_grid` AS `main_table`
LEFT JOIN `sales_order_item` ON sales_order_item.order_id = main_table.entity_id
LEFT JOIN `braintree_transaction_details` ON braintree_transaction_details.order_id = main_table.entity_id GROUP BY `main_table`.`entity_id` ORDER BY allocated_sources ASC
I have one extra column in grid i.e. Allocated Sources.
2
Answers
I got the solution for the same. Just override the module sales order grid & add the following code. Upgrade your module & Flush the cache. It will work.
1 - Create a new module with Magento standards 2 - Override file with this content view/adminhtml/ui_component/sales_order_grid.xml
Your problem will be solved. Thanks, Rashi
Please check the "allocated_sources" column in your database. I guess it hasn’t been created yet or you are joining the wrong table.