[Erp5-dev] start_date on non-movement object

[Łukasz Nowak]

Hello,

On 2008-03-22, 11:23:04
bartek <bartek at erp5.pl> wrote:

(...)
> AFAIK technically if you add Person portal type to "movement"
type
> group the start_date should be catalogged.
> 
> Of course it doesn't make any sense :D Person is not a movement, so
> this is not a clean way to do it. Come to think of that, maybe the
> date of birth should not be start_date...?

Well - it was made to be more generic - look at upgrade notes.

> > 2008-03-21T16:14:34 WARNING SQLCatalog buildSQLQuery could not build
> > sort index (start_date -> None)
> > 
> > How to sort/search using such property? It is not catalogued, isn't
> > it? As start/stop date is on movements/deliveries. Yes? No? I'm
> > stuck. Again. ;)
> > 
> > Well. And if I create new table in catalog, which will have
> > start_date column, catalog Persons in it. How to use that? Eg.
> > table would be named persondata. Editing start_date to
> > persondata.start_date is not disallowing sort/search, and Persons
> > object to have entries in persondata table...
> 
> Have you followed http://www.erp5.org/HowToAddTableToCatalog? Still 
> doesn't work?

Indeed. My persondata table has start_date and price - as I added price
to Person type. Everything is catalogued, but I'm able to search using
catalog with price property, using start_date do not work.

Regards,
Luke

-- 
Łukasz Nowak R&D Ventis http://www.ventis.com.pl/
tel: +48 32 768 16 85 fax: +48 32 392 10 61
``Use the Source, Luke...'' I am only craftsman.