How do you limit the number of db records selected?

I have a dashboard type page which is going to generate 4 database queries on big tables of symbols holding 50k rows. Only trying to return the top 10 records in each table, I only need to select that many rows.

I understand how to limit the display of a repeating group by the number of rows. However, past that I do not see anywhere to designate that I would like to only return 10 records in the query itself. I would also like to cache this group of queries.

Is anything like this possible?

You can just use :items until#

1 Like

That worked, thank you!

1 Like