我试图获得deletedAt列isNotNull但typeorm返回deletedAt列的条件的项目列表 const query = Results.createQueryBuilderdate" AS "results_date", "results"."shift" AS "results_shift", "results"."deletedAt" IS NULL )
我想将查询转移到TypeORM。SELECT * where (equipment_charging."start_date"::date, equipment_charging."end_date"::date) OVERLAPS (DATE '2020-09-10', DATE '2020-09-14'
这是我在以下代码中调用create()的代码: public async execute({ provider, date }:appointmentsRepository = getCustomRepository(AppointmentsRepository); if (foundAppointme
所以我使用date_trunc()和generate_series()来获取这种类型的记录。我做了psql查询,但是我需要把它转换成typeorm代码,因为我不熟悉typeorm堆栈。以下是查询 FROM (select date_trunc('MONTH', months) AS datefrom generate_series('2021-05-03'