[Erp5-dev] sql_search_tables not working? (innodb_catalog)

Jacek Medrzycki jacek at erp5.pl
Wed Apr 4 11:38:49 CEST 2007


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



More information about the Erp5-dev mailing list