Search code examples
lotus-dominolotus-formula

Find last created document in view

I am trying to create a view in Domino to find the last created document in each category. The Domino database holds records on college class reports and I have created a view with the first column as CollegeClass and the second column as DateCreated and the third column as ReportTitle. The CollegeClass column can have multiple entries of reports obviously and what I want to do is use a Lotus Notes Formula on the DateCreated column to only show the last report for each College Class. I have tried using @created in a few ways but no success as yet. How do I filter this to only show the latest report?

Solution

  • You can't achieve this with a view. A document in a view can't be hidden in dependence of another document.