fix(server): /places entries sometimes not ordered alphabetically (i…

…mmich-app#10514)
3urobeat · Jun 21, 2024 · 42f3b50 · 42f3b50
1 parent 5e9a7b1
commit 42f3b50
Show file tree

Hide file tree

Showing 2 changed files with 3 additions and 1 deletion.
diff --git a/server/src/queries/search.repository.sql b/server/src/queries/search.repository.sql
@@ -405,3 +405,5 @@ FROM
   "assets" "asset"
   INNER JOIN "exif" "exif" ON "exif"."assetId" = "asset"."id"
   INNER JOIN cte ON asset.id = cte."assetId"
+ORDER BY
+  exif.city
diff --git a/server/src/repositories/search.repository.ts b/server/src/repositories/search.repository.ts
@@ -52,7 +52,7 @@ export class SearchRepository implements ISearchRepository {
         .innerJoinAndSelect('asset.exifInfo', 'exif')
         .withDeleted()
         .getQuery() +
-      ' INNER JOIN cte ON asset.id = cte."assetId"';
+      ' INNER JOIN cte ON asset.id = cte."assetId" ORDER BY exif.city';
   }
 
   async init(modelName: string): Promise<void> {