in one of my apps i have a pricelist with prices for each client and product. when i add a new price, i also put in a date from where the new price is available.
so over the time the pricelist includes e.g.: product1 | dateFrom1 | price1 product2 | dateFrom1 | price1 product2 | dateFrom2 | price2 …
now i want to create a pricelist via Workflow rule where i want to show all products with last valid price
eg: product1 | dateFrom1 | price1 product2 | dateFrom2 | price2 …
in google docs template my START Expression <Start:RefColumnOfClientPrices> of course show all the entries for specific client. what would the select statement look like to limit the output to newest price for each product of specific client?
any help would be appreciated