[Erp5-dev] ERP5 - start date error

[pavel lstiburek]

Thanks again for help.

2012/10/11 Yusei TAHARA <yusei at nexedi.com>

> 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/
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> https://mail.tiolive.com/mailman/listinfo/erp5-dev
>



-- 
Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/d24f660e/attachment.htm>