When adding a new field in the sales order grid everything works well, but when you try to filter by date or some other field, you will get the below error message. Usually, it redirects to some other page and throws the Magento exception number screen, it’s horrible, isn’t it?
There has been an error processing your request
SQLSTATE: Integrity constraint violation: 1052 Column ‘status’ in where clause is ambiguous
By Modifying the status field in the form field array of custom module you can fix this,