fix: ignore null/undefined in where queries

1 files changed, 4 insertions, 0 deletions

diff --git a/src/database/Database.ts b/src/database/Database.ts

index 687474a3..5d1336e7 100644
--- a/src/database/Database.ts
+++ b/src/database/Database.ts
@@ -63,6 +63,10 @@ export const DataSourceOptions = isHeadlessProcess
           supportBigNumbers: true,
           name: "default",
           migrations: applyMigrations ? [path.join(__dirname, "migration", DatabaseType, "*.js")] : [],
+          invalidWhereValuesBehavior: {
+              null: "sql-null",
+              undefined: "ignore",
+          },
       });
 
 // Gets the existing database connection