Limit Records by Number


Cannot think my way through a BS table to simply limit the number of records to display. A date-sort query is called and only the first three records located by date should be displayed. (Short Upcoming Events list.)

I thought about the pagination table, but I do not want any more records to be available after 3.

The aggregate function in the query may be key but I need some direction.


Did you use the table generator?

If so:

  • select your table body
  • click on the lightning bolt after ‘expression’
  • click on the magic wand formatter
  • in the formatter add ‘Collections -> Top’
  • add a 3 where it says ‘Count’


Thanks - that was all of it. Saved me a lot of time experimenting.