When calling paginate and passing a repository as the first parameter and a searchOptions parameter that is just a FindOptionsWhere, none of the items in the FindOptionsWhere object show up in the resulting SQL. The only item that appears in the where is deletedAt = null which is automatically added by TypeORM. LIMIT does correctly show up in the SQL.
This seems due to the use of TypeORM's Repository.find method that only takes a FindManyOptions. Hence, if you take the FindOptionsWhere object and set it the searchOptions as { where: findOptionsWhere }, the resulting SQL is as expected.
When calling
paginateand passing arepositoryas the first parameter and asearchOptionsparameter that is just aFindOptionsWhere, none of the items in theFindOptionsWhereobject show up in the resulting SQL. The only item that appears in the where isdeletedAt= null which is automatically added by TypeORM. LIMIT does correctly show up in the SQL.This seems due to the use of TypeORM's Repository.find method that only takes a
FindManyOptions. Hence, if you take theFindOptionsWhereobject and set it thesearchOptionsas{ where: findOptionsWhere }, the resulting SQL is as expected.We are using v4.0.4 of nestjs-typeorm-paginate.