tree sort order

Gerhard,

The sort order is not controlled in a "view" but rather at the object level using the _order attribute. This can be found in the technical memento on page 2 in the "Predefined osv.osv attributes for business objects" section. If this is not defined for an object then it takes on the default which is order by 'id'.

Now that we have the "search layout more flexible in Version 6" what needs to be done is improvement on the filtering and returning results order view. Perhaps a new field to modify (order_by) selection filter and another field order (default, current view or all records) selection as well. So _order in an object sets the default order, if a user selects a different field in the "order_by" selection field on a view the results reorder, and a field to indicate whether to display results (default, within current view, within current filtered selection, or all records). Just an idea . . .

Here is an example from the base module res.partner - where the order is by name.

class res_partner_function(osv.osv):
    _name = 'res.partner.function'
    _description = 'Function of the contact'
    _columns = {
        'name': fields.char('Function Name', size=64, required=True),
        'code': fields.char('Code', size=8, required=True),
        'ref':fields.char('Notes', size=32,),
    }
    _order = 'name'
    _sql_constraints = [
        ('code_uniq', 'unique (code)', 'The Code of the Partner Function must be unique !')
    ]
res_partner_function()

You can also have more than one field value in the _order field for example: _order = 'parent_id,name'. You'll find this example in the base module in res.partner (def _check_recursion(self, cr, uid, ids):).

The only way to change the behavior of "when you click on a column heading to sort through the entire set of records" versus only through the visible view is to write code to do so for the GTK client and the Web client separately. (We've seen it done with the GTK client on 5.0 but not in the web-client to to date. As ChriCar indicates the feedback we've always been told is that it is slow as a result.

I hope this provides at least some guidance.