Related fields don't honour the search ordering.

[Vivek poddar]

Hi,

I caught this bug when I was using XML-RPC to sort my custom model's record on the basis of name. The 'name' field in my custom model is a related field to 'Product model'. When tried searching on my model with name as the order it gave me the same record ids as it gave without using the order parameter.

My field defintion:
'name': fields.related('product_id', 'name', type='char', string="Name", readonly=True, store=False)

My Test case:
1. proxy.execute('MY_DB', 1, 'a', 'MY_MODEL', 'search', [], 0, 5, 'name asc')
    result = [1, 2, 3, 4, 5]
2. proxy.execute('MY_DB', 1, 'a', 'MY_MODEL', 'search', [], 0, 5, 'name desc')
    result = [1, 2, 3, 4, 5]
3. proxy.execute('MY_DB', 1, 'a', 'MY_MODEL', 'search', [], 0, 5, 'name asc')
    result = [51, 45, 21, 4, 5] , works good as name is a character field here.

I am using V6.1.

[Vivek poddar (vivekimsit)]

Hi,

It seems this bug is effective only when the related field is not stored in DB. Otherwise it works as expected.
But I will assume it as a bug.

Thanks and Regards!

[Kinner Vachhani (kinner-vachhani)]

The patch uploaded by Camp2camp in below link will solve your problem.
https://bugs.launchpad.net/openobject-server/+bug/629332

[Jignesh Rathod(OpenERP) (jir-openerp)]

Hello Vivek ,

I agree with you , When searching record with the order it does not return
ids in correct order. Its good to implement , So I am confirming this issue.

Thanks for reporting.