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

Problem with in operator and documents with array properties #1551

Open
yoedusvany opened this issue Sep 19, 2022 · 1 comment
Open

Problem with in operator and documents with array properties #1551

yoedusvany opened this issue Sep 19, 2022 · 1 comment

Comments

@yoedusvany
Copy link

yoedusvany commented Sep 19, 2022

Hello

I'm having an issue with documents that have an array properties like that

document: person
properties:

  • name
  • desc
  • contracts
    -- age
    -- type

I want to filter with in operator over type property, posible values for this property are "part time", "full time", "remote"

The filter that I'm passing is:

'contracts.type': {
in: ["part time", "full time"]
}

but I'm getting the following error ERROR BadRequestException: unknown comparison field contracts.type

I tested it in the database

db.getCollection("person").find({
"contracts.type": {
"$in": ["part time", "full time"]
}
})

and I got documents, so I think there is a problem with the library. I tested other operators like iLike, eq, and so on ok

I'm using the following versions

"@nestjs-query/core": "0.30.0",
"@nestjs-query/query-mongoose": "0.30.0",
@TriPSs
Copy link

TriPSs commented Sep 26, 2022

If I would have to make a quess I think the filter is defined wrong and should look more like this:

{
  contracts: {
     type: { in: ["part time", "full time"] }
  }
}

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

2 participants