Sales Order Grid is not working when filtering using any field in magento admin
Hello Friends, I know that many developers face this issue when they adding any new custom field to sales order grid. I have also suffered with this issue and i found the solution for that. Please read the following step to fix this issue.
1. Go to app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php
2. Add the following code to the field which causes the issue.
3. Save that file.
Note: This is example for only one field if you suffer with the same issue with many fields then you have to add this code as per the field index name.
1. Go to app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php
2. Add the following code to the field which causes the issue.
'filter_index'=>'main_table.increment_id',
3. Save that file.
Note: This is example for only one field if you suffer with the same issue with many fields then you have to add this code as per the field index name.
Pritesh

Pritesh Pethani