product grid -- sorting by product id column broken about mage-enhanced-admin-grids HOT 4 CLOSED

Encountered this problem once, the only thing I remember is that it got fixed by itself rather randomly, not sure then if this is directly related to the Stock Availability column (have tried it just now on both 1.6 and 1.7 and the sort is working).
There must be other pre-requisites for the problem to occur, the only thing is to figure which ones.

from mage-enhanced-admin-grids.

Finally encountered it again, in fact it happens on EAV entity grids for which fields are mapped in order to prevent ambiguous filters, once that at least one custom column is added and a filter is applied.
The problem seems to come from the fact that EAV-based collections don't handle well mapped fields. Eg, if you want to filter on product ID, the mapped field is e.entity_id, but as the collection can only recognize entity_id (field without table alias), it does not apply the corresponding order.
Will look into it as soon as possible, but have yet to find which is the better way to fix this.

EDIT : seems to affect 1.7+ versions only (caused in fact by new Mage_Eav_Model_Entity_Collection_Abstract::_renderOrders() method)

from mage-enhanced-admin-grids.

Fixed by 06d1f1c (there might be other solutions but the current one should conveniently do the trick).
Thanks for having reported this issue ! :)

from mage-enhanced-admin-grids.

Sweet! Works perfectly now.

Thanks again!

from mage-enhanced-admin-grids.