Limit Records by Number

Wappler General How To
#1

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.

#2

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’

21%20PM
Screen Shot 2019-04-09 at 3.28.21 PM.png806×476 26.7 KB

2 Likes
#3

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

Dana

2 Likes