[Erp5-dev] listbox - sort by formatted column

[bartek]

Hello

What's The Right Way to display a formatted data (e.g. date) in a
listbox column and at the same time allow sorting by it?

The best solution I could come up with was putting a script like
Base_formatCreationDate(brain, selection)
as a listbox column and then processing kw['sort_on'] in the listboxes
List Method to replace ('Base_formatCreationDate', 'ascending') with
('creation_date', 'ascending').

But it doesn't seem to be an elegant solution...

Bartek

[Jérôme Perrin]

Post by bartek
Hello
What's The Right Way to display a formatted data (e.g. date) in a
listbox column and at the same time allow sorting by it?
The best solution I could come up with was putting a script like
Base_formatCreationDate(brain, selection)
as a listbox column and then processing kw['sort_on'] in the listboxes
List Method to replace ('Base_formatCreationDate', 'ascending') with
('creation_date', 'ascending').

Use an editable field listbox_creation_date, sorting and searching will then
use creation_date.
If you want to display a custom value, the brain for the current line is
"cell" in TALES context.

J?rome

[bartek]

Post by Jérôme Perrin

Post by bartek
Hello
What's The Right Way to display a formatted data (e.g. date) in a
listbox column and at the same time allow sorting by it?
The best solution I could come up with was putting a script like
Base_formatCreationDate(brain, selection)
as a listbox column and then processing kw['sort_on'] in the listboxes
List Method to replace ('Base_formatCreationDate', 'ascending') with
('creation_date', 'ascending').

Use an editable field listbox_creation_date, sorting and searching will then
use creation_date.
If you want to display a custom value, the brain for the current line is
"cell" in TALES context.

...and didn't think about using DateField :)

Thanks
Bartek

Post by Jérôme Perrin
J?rome
_______________________________________________
Erp5-dev mailing list
Erp5-dev at erp5.org
http://erp5.org/mailman/listinfo/erp5-dev