[Erp5-dev] ZSQLCatalog sort-on parameter

[Sebastien Robin]

Hi all,

As a reminder, it is possible to use the sort-on parameter to get an
ordered list when we call searchFolder or portal_catalog, like this:

portal_catalog(portal_type='resource',sort-on=[('reference','ascending')])

Let's say you have 3 references ('1','2','15'), you will have objects
sorted with the following references :

['1','15','2']

In this case, the reference is like a text in mysql so, it will probably
not in the order expected. So I added one more parameter (it is optional)
to sort-on, and if your references are only numbers, you can use this :

portal_catalog(portal_type='resource',sort-on=[('reference','ascending','int')])

This use the following thing in mysql :

ORDER BY CAST(reference AS SIGNED)

Then the order will be like this :

['1','2','15']

It is working very fast with MySQL (I tried with a lot of data), and it
does not fails if there some string instead of numbers.

This is also working with related keys, and ZSQLCatalog.

Seb.