How do I make a SQL that fetches the newest rows, but reorder them, so that the newest is at the bottom of the output
like:
6 5 4 3 2 1
Instead of
1 2 3 4 5 6
How can i do this?
Model::find([
"order" => "id desc" // or when creating records add field create_at = time(), and order by it ASC
]);?
I think you misunderstod me, i want to fetch the newest records, but then reorder them, so the newest is at the bottom and the oldest on op
$resultSet = $this->modelsManager->createQuery("
SELECT * FROM (SELECT * FROM [Robots] ORDER BY id DESC LIMIT 10) tmp ORDER BY id ASC
")->execute();Not sure if this will work with PHQL, but that is how you'd do it with mysql.
You could also convert your original ResultSet to array, and issue array_reverse, but that's not a robust solution performance-wise
Hi,
if I understand, you want to sort your resultset in the view environment. There is a "sort" filter implemented in volt, see: https://docs.phalcon.io/en/latest/reference/volt.html#filters, but it will sort your items in an ASC order
I think, you will have to create your own filter to achieve what you exactly need, see https://docs.phalcon.io/en/latest/reference/volt.html#id2