2 files changed, 6 insertions, 2 deletions
diff --git a/Digitigrade/Model.php b/Digitigrade/Model.php
index dca1484..4a206a6 100644
--- a/Digitigrade/Model.php
+++ b/Digitigrade/Model.php
@@ -157,13 +157,17 @@ abstract class Model {
         string $whereClause,
         array $parameters,
         ?int $limit = null,
-        int $offset = 0
+        int $offset = 0,
+        ?string $orderByClause = null
     ): array {
         $classNameParts = explode('\\', static::class);
         $className = $classNameParts[count($classNameParts) - 1];
         $tableName = self::mangleName($className);
 
         $query = "SELECT * FROM $tableName WHERE $whereClause";
+        if ($orderByClause != null) {
+            $query .= " ORDER BY $orderByClause";
+        }
         if ($limit != null) {
             $query .= " LIMIT $limit OFFSET $offset";
         }
diff --git a/Digitigrade/Model/Note.php b/Digitigrade/Model/Note.php
index 37ddff3..3c0c690 100644
--- a/Digitigrade/Model/Note.php
+++ b/Digitigrade/Model/Note.php
@@ -103,7 +103,7 @@ class Note extends PushableModel {
     }
 
     public static function findAllWithAuthor(Actor $author, ?int $limit = null, int $offset = 0): array {
-        return self::findAllWhere('author = ?', [$author->id], $limit, $offset);
+        return self::findAllWhere('author = ?', [$author->id], $limit, $offset, 'created DESC');
     }
 
     public function getInteractions(): array {