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 ?
