Does Xano have a function similar to SQL SELECT TOP(10) or Linq .Take(10)

Mr_English

While I am developing, I want to run my function stack against a limited number or records, rather than all of them. Does Xano have a function similar to SQL SELECT TOP(10) or Linq .Take(10) ?

Thanks.

Michael Udinski

Hi @Mr_English this is accomplished with paging in the Query All Records function. Just turn on paging and set the per_page value to 10. You can always leverage sorting if you want those records in a certain order such as a top 10 of whatever value