Sorting Accounts field in a subpanel

[killroy]

Hi,

I've noticed that, for example, Contacts module or any other module which contains a subpanel with Accounts field fails to sort by Accounts.
If I open a Contacts detail view and try to sort by Account name in Opportunities subpanel, it will sort it the first time, but then the second time it just stays the same, while it should be sorted in reversed order.

I inspected sugar log file and the problem is in a generated SQL

SELECT opportunities.id , opportunities.name , ' ' account_name , ' ' account_id , opportunities.sales_stage , opportunities.date_closed , opportunities.amount , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, opportunities.amount_usdollar , opportunities.assigned_user_id , 'opportunities' panel_name FROM opportunities LEFT JOIN users jt1 ON
jt1.id= opportunities.assigned_user_id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN opportunities_contacts ON (opportunities.id=opportunities_contacts.opportuni ty_id AND opportunities_contacts.contact_id='420e9afa-d7f4-4488-ba39-4538e158f20d') where ( opportunities_contacts.deleted=0 AND opportunities.deleted=0) AND opportunities.deleted=0 ORDER BY account_name desc

I guess it can't sort the query because account_name doesn't exist as a valid field. does anyone know how to make this right?
Thanks.

[JWG]

We also are struggling to sort out this problem. Any suggestions?

Thanks.