[Erp5-dev] ERP5 - start date error

[Yusei TAHARA]

Hi,

In such case, you first need to add a custom mysql table and
corresponding zsqlmethods to portal_catalog. Because portal_catalog
does not cover all properties of document. Only some specific
properties are searchable.

About person document, it has start_date, but it is not a
delivery/movement. Thus person's start_date is not indexed and it is
not searchable by default.

erp5_ingestion_mysql_innodb_catalog is a good example to know how
to extend catalog.

Regards,
Yusei


On Thu, 11 Oct 2012 11:33:04 +0200
pavel lstiburek <plstiburek at gmail.com> wrote:

> Thanks, this will do most of times.
> But what if i for example need to find all person older than 20. If try to
> find it by date i get error.
> Person is not movement or delivery. How to deal with such case?
> 
> Pavel Lstiburek
> 
> 2012/10/11 Yusei TAHARA <yusei at nexedi.com>
> 
> > Hi,
> >
> > There are two sets of date time columns in catalog. One is
> > delivery.start_date and delivery.stop_date. The other one is
> > movement.start_date and movement.stop_date.
> >
> > If you search movement type document like sale order line, sale
> > packing list line, you need to use "movement.start_date". And
> > if you search delivery type doucment like sale order, sale
> > packing list, then you need "delivery.start_date".
> >
> > And then you also need to add listbox_delivery_start_date datetime
> > field to listbox to control datetime formating for example.
> >
> > You can find many example implementations. One good example is
> > portal_skins/erp5_trade/SaleOrderModule_viewSaleOrderList in
> > erp5_trade business template.
> >
> > Regards,
> > Yusei
> >
> > On Thu, 11 Oct 2012 11:05:10 +0200
> > pavel lstiburek <plstiburek at gmail.com> wrote:
> >
> > > Hi,
> > > i keep running into problems with start_date and stop_date.
> > > Usualy it says me *Could not map those columns: set(['stop_date'])*
> > > I coudnt search by it, but searching with creation_date is no problem.
> > > Can someone tell how to fix this error, or where can i look for script
> > that
> > > defines start_date or stop_date?
> > >
> > > --
> > > Pavel Lstiburek
> >
> >
> > --
> > Yusei TAHARA <yusei at nexedi.com>
> > Nexedi: Consulting and Development of Free / Open Source Software
> > http://www.nexedi.co.jp/
> > ERP5: Full Featured High End Open Source ERP
> > http://www.erp5.com/
> > ERP5 Wiki: Developer Zone for ERP5 Community
> > http://www.erp5.org/
> > _______________________________________________
> > Erp5-dev mailing list
> > Erp5-dev at erp5.org
> > https://mail.tiolive.com/mailman/listinfo/erp5-dev
> >
> 
> 
> 
> -- 
> Pavel Lstiburek


-- 
Yusei TAHARA <yusei at nexedi.com>
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.co.jp/
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com/
ERP5 Wiki: Developer Zone for ERP5 Community
http://www.erp5.org/