[Erp5-dev] start_date on non-movement object

[Ivan Tyagov]

Hi,

?ukasz Nowak wrote:
> Hello,
> 
> On 2008-03-25, 09:37:11
> bartek <bartek at erp5.pl> wrote:
> 
> (...)
>> What are the results of:
>>
>> context.portal_catalog(portal_type='Person', price=123, src__=1)
>> context.portal_catalog(portal_type='Person', start_date='2001/01/01' 
>> src__=1)
>> kw = {'portal_type':'Person', 'persondata.start_date':'2001/01/01', 
>> 'src__':1}
>> context.portal_catalog(**kw)

Please try got to:
portal_catalog/erp5_mysql_innodb/manage_propertiesForm
and set/select in 'sql_catalog_datetime_search_keys' as DateTime Search
Key persondata.start_date.

Currently ZSQLCatalog doesn't not EXPLICITLY determine search key used 
for querying especially when using a custom catalog table. This means 
that in query generation the dates you use are not converted to UTC in 
the SQL generation process while in MySLQ they are saved in UTC.
Regards
Ivan


-- 
Ivan Tyagov
ERP5 Enterprise: Free / Open Source ERP for Critical Applications
http://www.erp5.com
ERP5 Express: Hosted Open Source ERP for small companies
http://www.myerp5.com
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com