Thanks, this will do most of times.<div>But what if i for example need to find all person older than 20. If try to find it by date i get error.<div>Person is not movement or delivery. How to deal with such case?</div><div>
<br></div><div>Pavel Lstiburek<br><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>
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>
<div class="im"><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>
</div>> Usualy it says me *Could not map those columns: set(['stop_date'])*<br>
<div class="HOEnZb"><div class="h5">> 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 that<br>
> defines start_date or stop_date?<br>
><br>
> --<br>
> Pavel Lstiburek<br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<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>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br>Pavel Lstiburek<br>
</div></div>