[Erp5-dev] start_date on non-movement object

[bartek]

Łukasz Nowak wrote:
> 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.
> 

Did you select persondata table as search table in catalog properties?

B

> Regards,
> Luke
>