Returning the "x" last records from the table, but in ascending order

brunoantoni

Hello.

How do I make a query on a table, returning the "x" last records from the table, but in ascending id order?

Thank very much for help.

Pawel Magdanski

No problem at all.

There is a filter "sort" that you can use:

Pawel Magdanski

Hi,

I would use pagination to return the number of records you need plus add sorting by created_at/id descending. then you can create variable with the result of the query and sort it by id ascending.

brunoantoni

First, thank you for the response.

But how can I sort a variable?

brunoantoni

It worked perfectly. Thank you very much for the help.