where are the default sort orders for each module stored?

[napx]

I'm getting the following error (as mentioned in another thread):

Error retrieving Case list: Query Failed:SELECT cases.*, accounts.name as account_name1, accounts.assigned_user_id account_name1_owner, users.user_name as assigned_user_name , cases_cstm.* FROM cases LEFT JOIN users ON cases.assigned_user_id=users.id LEFT JOIN accounts ON cases.account_id=accounts.id LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c where cases.deleted=0 AND accounts.deleted=0 ORDER BY cases.assigned_user_name desc LIMIT 0,20::MySQL error 1054: Unknown column 'cases.assigned_user_name' in 'order clause'

If I edit Cases.php:create_list_query() and don't use the $order_by value that's passed in I don't get this error, so something is passing in a bad default value for the cases order by sort (cases.assigned_user_name, which obviously doesn't exist). Can someone point me in the right direction? Thanks.

[napx]

In case anyone else is stuck, I fixed this by changing the setQuery line to:

$ListView->setQuery($where, "", "case_number DESC", "CASE", false);

(override set to false, was previously true)