Portal record filter on grandparent-parent-child relationship
We have a Customer layout which show detail of customer information. And we need to have an OrderDetail portal records on the customer layout also. The portal record will display specific SKU which was order during a period of date. We will apply two filters to the portal. a). Filter by SKU - enabled by Portal Setup Filter portal record. It works. b). we need to filter a date range also. The date is in Order table which is in parent table. How can we filter it by a date range?