Jacek Medrzycki
2007-04-04 09:38:49 UTC
Hi
I had to sort on start_date in a listbox. As I see, start_date is in the
movement table and this table is in the sql_search_tables. The table
contains rows for my objects with correct start_date values. However,
listbox doesn't show start date column as sortable. Portal_catalog does
not use this table (checked with src__=1 parameter).
So I created another table, as described on wiki:
http://erp5.org/HowToAddTableToCatalog. Again, indexing works and my
table contains correct rows. I've added the table to the
sql_search_tables. However, again it is not used by portal_catalog.
The question is - what is the correct way to have start_date sortable by
catalog?
Jacek
I had to sort on start_date in a listbox. As I see, start_date is in the
movement table and this table is in the sql_search_tables. The table
contains rows for my objects with correct start_date values. However,
listbox doesn't show start date column as sortable. Portal_catalog does
not use this table (checked with src__=1 parameter).
So I created another table, as described on wiki:
http://erp5.org/HowToAddTableToCatalog. Again, indexing works and my
table contains correct rows. I've added the table to the
sql_search_tables. However, again it is not used by portal_catalog.
The question is - what is the correct way to have start_date sortable by
catalog?
Jacek