AnsweredAssumed Answered

To show products and last purchase date on a portal

Question asked by lluiscooking on Mar 14, 2016
Latest reply on Mar 14, 2016 by beverly

Good afternoon


I have standard solution with following scheme


COSTUMER/ costumer_ORDERS / costumer_orders_LINEITEM / costumer_order_lineitem_PRODUCT.


I  have a portal showing all products from a client. I can do that by using records from the last TO (costumer_order_lineitem_PRODUCT). This is not a problem.

Instead of this I would like to have a portal showing:


Product     Last purchase date (of the product)     Last price (of the product)


To do this, I think I should use the data from (costumer_orders_LINEITEM). I guess I should filter the portal in order to show only the last LINEITEM record containing each product. Or perhaps there's another way to do. I guess this must a common request.

Can anybody help me on that?.


Thanks for your help.