Thanks again for help.<div><br><div class="gmail_quote">2012/10/11 Yusei TAHARA <span dir="ltr"><<a href="mailto:yusei@nexedi.com" target="_blank">yusei@nexedi.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
In such case, you first need to add a custom mysql table and<br>
corresponding zsqlmethods to portal_catalog. Because portal_catalog<br>
does not cover all properties of document. Only some specific<br>
properties are searchable.<br>
<br>
About person document, it has start_date, but it is not a<br>
delivery/movement. Thus person's start_date is not indexed and it is<br>
not searchable by default.<br>
<br>
erp5_ingestion_mysql_innodb_catalog is a good example to know how<br>
to extend catalog.<br>
<br>
Regards,<br>
Yusei<br>
<br>
<br>
On Thu, 11 Oct 2012 11:33:04 +0200<br>
<div class="HOEnZb"><div class="h5">pavel lstiburek <<a href="mailto:plstiburek@gmail.com">plstiburek@gmail.com</a>> wrote:<br>
<br>
> Thanks, this will do most of times.<br>
> But what if i for example need to find all person older than 20. If try to<br>
> find it by date i get error.<br>
> Person is not movement or delivery. How to deal with such case?<br>
><br>
> Pavel Lstiburek<br>
><br>
> 2012/10/11 Yusei TAHARA <<a href="mailto:yusei@nexedi.com">yusei@nexedi.com</a>><br>
><br>
> > Hi,<br>
> ><br>
> > There are two sets of date time columns in catalog. One is<br>
> > delivery.start_date and delivery.stop_date. The other one is<br>
> > movement.start_date and movement.stop_date.<br>
> ><br>
> > If you search movement type document like sale order line, sale<br>
> > packing list line, you need to use "movement.start_date". And<br>
> > if you search delivery type doucment like sale order, sale<br>
> > packing list, then you need "delivery.start_date".<br>
> ><br>
> > And then you also need to add listbox_delivery_start_date datetime<br>
> > field to listbox to control datetime formating for example.<br>
> ><br>
> > You can find many example implementations. One good example is<br>
> > portal_skins/erp5_trade/SaleOrderModule_viewSaleOrderList in<br>
> > erp5_trade business template.<br>
> ><br>
> > Regards,<br>
> > Yusei<br>
> ><br>
> > On Thu, 11 Oct 2012 11:05:10 +0200<br>
> > pavel lstiburek <<a href="mailto:plstiburek@gmail.com">plstiburek@gmail.com</a>> wrote:<br>
> ><br>
> > > Hi,<br>
> > > i keep running into problems with start_date and stop_date.<br>
> > > Usualy it says me *Could not map those columns: set(['stop_date'])*<br>
> > > I coudnt search by it, but searching with creation_date is no problem.<br>
> > > Can someone tell how to fix this error, or where can i look for script<br>
> > that<br>
> > > defines start_date or stop_date?<br>
> > ><br>
> > > --<br>
> > > Pavel Lstiburek<br>
> ><br>
> ><br>
> > --<br>
> > Yusei TAHARA <<a href="mailto:yusei@nexedi.com">yusei@nexedi.com</a>><br>
> > Nexedi: Consulting and Development of Free / Open Source Software<br>
> > <a href="http://www.nexedi.co.jp/" target="_blank">http://www.nexedi.co.jp/</a><br>
> > ERP5: Full Featured High End Open Source ERP<br>
> > <a href="http://www.erp5.com/" target="_blank">http://www.erp5.com/</a><br>
> > ERP5 Wiki: Developer Zone for ERP5 Community<br>
> > <a href="http://www.erp5.org/" target="_blank">http://www.erp5.org/</a><br>
> > _______________________________________________<br>
> > Erp5-dev mailing list<br>
> > <a href="mailto:Erp5-dev@erp5.org">Erp5-dev@erp5.org</a><br>
> > <a href="https://mail.tiolive.com/mailman/listinfo/erp5-dev" target="_blank">https://mail.tiolive.com/mailman/listinfo/erp5-dev</a><br>
> ><br>
><br>
><br>
><br>
> --<br>
> Pavel Lstiburek<br>
<br>
<br>
--<br>
Yusei TAHARA <<a href="mailto:yusei@nexedi.com">yusei@nexedi.com</a>><br>
Nexedi: Consulting and Development of Free / Open Source Software<br>
<a href="http://www.nexedi.co.jp/" target="_blank">http://www.nexedi.co.jp/</a><br>
ERP5: Full Featured High End Open Source ERP<br>
<a href="http://www.erp5.com/" target="_blank">http://www.erp5.com/</a><br>
ERP5 Wiki: Developer Zone for ERP5 Community<br>
<a href="http://www.erp5.org/" target="_blank">http://www.erp5.org/</a><br>
_______________________________________________<br>
Erp5-dev mailing list<br>
<a href="mailto:Erp5-dev@erp5.org">Erp5-dev@erp5.org</a><br>
<a href="https://mail.tiolive.com/mailman/listinfo/erp5-dev" target="_blank">https://mail.tiolive.com/mailman/listinfo/erp5-dev</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Pavel Lstiburek<br>
</div>