Hi Jacques, Just to mention that in the example given by twosolution, the database records are correct. However he has some misunderstanding on how 'thru date' in OFBiz meant.
Jacques Le Roux wrote > Seems that I forgot this one > https://issues.apache.org/jira/browse/OFBIZ-3161 > > Too much things on my plate :/ I will try to review... > > Jacques > > Le 31/05/2014 01:44, Jen Sing Choe a écrit : >> Even if i apply ordering, it will still create confusing especially on >> the >> ecommerce/PO/invoice >> I feel a bit weird that out-of-the-box, ofbiz does not prevent >> over-lapping >> on the time-based condition. >> Ofbiz only prevent the from having the same start date. >> Is it better, if there is over-lapping time-based checking (on date >> without >> timestamp) ? >> >> >> >> >> On Fri, May 30, 2014 at 2:59 PM, james_sg < > snowmedal@ > > wrote: >> >>> Hi, >>> >>> In the database, the dates are stored with non-zero time. >>> When selecting a price, you can choose to filter with a date with zero >>> time. >>> So the effect is you will retrieve only 1 record. >>> >>> >>> twosolution wrote >>>> Hi, >>>> In product pricing, we can define multiple record >>>> >>>> PRIMARY KEY (product_id, product_price_type_id, >>>> product_price_purpose_id, >>>> currency_uom_id, product_store_group_id, from_date) >>>> >>>> My below scenario is at below >>>> >>>> (1 + 2 + 3 + 4 + 5 + 2Jan2014 ) and thruDate = 15Jan2014 >>>> (1 + 2 + 3 + 4 + 5 + 15Jan2014 ) and thruDate is null >>>> >>>> >>>> and i would like to return 15jan2014 pricing, and i will return 2 >>> records. >>>> And assuming timestamp is not important in this scenario. Just only the >>>> date >>>> >>>> What is the current practice of choosing which record to retrieve ? >>>> >>>> -- >>>> Disclaimer : This E-mail is intended only for the use of the individual >>> or >>>> entity named above and may contain information that is confidential. If >>>> you >>>> are not the intended recipients, please immediately notify us by return >>>> email and delete it from your system. Any unauthorised dissemination, >>>> distribution or copying of this email is strictly prohibited. Thank >>>> You. >>> >>> >>> >>> >>> -- >>> View this message in context: >>> http://ofbiz.135035.n4.nabble.com/Product-Pricing-multiple-time-based-record-tp4651240p4651249.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> > > -- -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Pricing-multiple-time-based-record-tp4651240p4651296.html Sent from the OFBiz - User mailing list archive at Nabble.com.
