Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using FindOptionsWhere not working #915

Open
jlbrown-ren opened this issue Aug 19, 2024 · 0 comments
Open

Using FindOptionsWhere not working #915

jlbrown-ren opened this issue Aug 19, 2024 · 0 comments

Comments

@jlbrown-ren
Copy link

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.

We are using v4.0.4 of nestjs-typeorm-paginate.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant