Skip to Main Content

Share your product feedback

Filter by 'Latest record'

We store status updates in a custom table on the Activity record. When retrieving status reports for reporting we need the 'latest report'; if we use a date range we retrieve multiple records for some activities.

  • Attach files
      Drop here to upload
    • Lindsay Zandy
      Reply
      |
      May 10, 2022

      I desperately need this as well - ability to filter on the most recent or max effective dated row in a custom table. When I pull a report it gives me all of the historical entries which isn't useful.