fix(server): metadata extraction job on missing does not include file with missing nullable field

2025-12-06 17:23:10 +03:00 · 2025-03-29 21:07:29 -05:00
1 changed files with 9 additions and 2 deletions
--- a/server/src/repositories/asset.repository.ts
+++ b/server/src/repositories/asset.repository.ts
@@ -683,8 +683,15 @@ export class AssetRepository {
      .$if(property === WithoutProperty.EXIF, (qb) =>
        qb
          .leftJoin('asset_job_status as job_status', 'assets.id', 'job_status.assetId')
-          .where((eb) => eb.or([eb('job_status.metadataExtractedAt', 'is', null), eb('assetId', 'is', null)]))
-          .where('assets.isVisible', '=', true),
+          .where((eb) =>
+            eb.or([
+              eb('job_status.metadataExtractedAt', 'is', null),
+              eb('assetId', 'is', null),
+              eb('assets.fileCreatedAt', 'is', null),
+              eb('assets.fileModifiedAt', 'is', null),
+              eb('assets.localDateTime', 'is', null),
+            ]),
+          ),
      )
      .$if(property === WithoutProperty.FACES, (qb) =>
        qb