SAO order column in a tree list

Support Developer
1

Hi,

If I request the db directly with ‘select position_id from position order by position_id ASC’ , I get exatly what I want:
CP1456
CP1456/1
CP1457

position_id is a fields.Char
but impossible to get this order in the sao client, I get this:
CP1456
CP1457
CP1456/1

even if I define the order_position_id function like that:

@classmethod
def order_position_id(cls, tables):
    table, _ = tables[None]
    return [Tonumber(Substring(table.position_id,3,4))]

Any idea ?

Tks,
Laurent

2

Are you sure you did not implement another order_position_id which use CharLength?

3

yes sure.
Just have this line in __setup__(cls):
cls.position_id.search_unaccented = False

4

Oh I’ve found the problem, the class is derivated from the wrong based class tks for assistance on saturday