ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adrian Crum <adrian.c...@sandglass-software.com>
Subject Re: Product Pricing - multiple time-based record
Date Thu, 29 May 2014 15:45:08 GMT
In existing code, the first item in the list is used. Most of the time, 
no order is set - so the result can be unpredictable (the first item in 
the list will depend upon the ordering in the data source).

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 5/29/2014 5:04 AM, Jen Sing Choe 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 ?
>

Mime
View raw message