typrom返回SQL查询，并具有ISNULL和ISNOTNULL的条件

Question

我正在尝试获取DeletEdat列ISONOTNULL的项目列表，但是Typeorm正在返回DeletEdat列的条件

typeorm

    const query = Results.createQueryBuilder('results');
    query.where('results.deletedAt IS NOT NULL');
    query.skip(page * limit);
    query.take(limit);
    console.log(query.getQuery());
    return query.getManyAndCount();

它返回 sql query 如下

SELECT "results"."id" AS "results_id", "results"."date" AS "results_date", "results"."shift" AS "results_shift", "results"."result" AS "results_result", "results"."createdAt" AS "results_createdAt", "results"."updatedAt" AS "results_updatedAt", "results"."deletedAt" AS "results_deletedAt" FROM "results" "results" WHERE ( "results"."deletedAt" IS NOT NULL ) AND ( "results"."deletedAt" IS NULL ) LIMIT 10

packages

    "typeorm": "^0.3.7"
    "@nestjs/typeorm": "^8.1.4",
    "@nestjs/common": "^8.0.0",

Answer 1

我猜结果实体中有一个@deletedatecolumn吗？如果是，为null将自动应用零件，以及您手动输入的部分。