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 <[email protected]> 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. > -- 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.
