AnsweredAssumed Answered

Searching last records in list view

Question asked by MrBond on Jul 1, 2016
Latest reply on Jul 2, 2016 by MrBond



I have three tables. One of them is the line items table. Now I have a list view based on this line items table.

In this layout I have five fields placed: "from" "until" (from line items table), "name" and "status" from tableA and "name" from tableB. There are several records where the "status" is "active" and the fields "from" and "until" are filled with data. Now I want to filter this list that there is only one record per "name" displayed and the "until" date is the most recent date (the newest date).


Thank you for any help!