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.