Query $in doesn't works with _id

[Buom01]

Steps to reproduce

Make a query on the client:

app.service('users').find({
    _id: {
        $in: ["USER1_ID", "USER2_ID"]
    }
})

Or in REST : http://localhost:3030/users?_id[$in]=USER1_ID&_id[$in]=USER2_ID

With existing users ID;

Expected behavior

It should return users who are listed by their ID in $in property

Actual behavior

It return that no user match:
{"total":0,"limit":50,"skip":0,"data":[]}

Probably IDs should be converted anywhere

System configuration

MongoDB on linux 64 for the collection "users"

$ mongod --version
db version v3.6.1
git version: 025d4f4fe61efd1fb6f0005be20cb45a004093d1
OpenSSL version: OpenSSL 1.1.0g  2 Nov 2017
allocator: tcmalloc
modules: none
build environment:
    distarch: x86_64
    target_arch: x86_64

Module versions (especially the part that's not working) (On server):

$ npm list | grep mongo
├─┬ feathers-mongodb@3.0.0
├─┬ mongodb@3.0.1
│ └─┬ mongodb-core@3.0.1

$ npm list | grep feathers
├─┬ @feathersjs/authentication@2.1.0
│ ├── @feathersjs/commons@1.3.0
│ ├── @feathersjs/errors@3.2.0 deduped
│ ├─┬ @feathersjs/socket-commons@3.1.5
│ │ ├── @feathersjs/errors@3.2.0 deduped
├─┬ @feathersjs/authentication-jwt@1.0.1
│ ├── @feathersjs/errors@3.2.0 deduped
├─┬ @feathersjs/authentication-local@1.0.2
│ ├── @feathersjs/errors@3.2.0 deduped
├─┬ @feathersjs/configuration@1.0.1
├─┬ @feathersjs/errors@3.2.0
├─┬ @feathersjs/express@1.1.2
│ ├── @feathersjs/commons@1.3.0 deduped
│ ├── @feathersjs/errors@3.2.0 deduped
├─┬ @feathersjs/feathers@3.0.2
│ ├── @feathersjs/commons@1.3.0 deduped
├─┬ @feathersjs/socketio@3.0.1
│ ├── @feathersjs/socket-commons@3.1.5 deduped
├─┬ feathers-authentication-hooks@0.1.6
│ ├─┬ feathers-errors@2.5.0
├─┬ feathers-blob@1.3.1
├─┬ feathers-hooks-common@4.1.0 (git://github.com/feathers-plus/feathers-hooks-common.git#c99e4d51cbbf482f28137a574d61ef1b5a608363)
│ ├── @feathers-plus/batch-loader@0.3.0
│ ├── @feathersjs/commons@1.3.0 deduped
│ ├── @feathersjs/errors@3.2.0 deduped
├─┬ feathers-hooks-validate-joi@1.0.3
│ ├── feathers-errors@2.5.0 deduped
│ ├─┬ feathers-hooks-common@1.7.2
│ │ ├─┬ feathers-hooks-utils@0.1.3
│ │ │ └─┬ feathers-authentication@0.7.9
│ │ │   ├── feathers-errors@2.5.0 deduped
│ │ │   ├─┬ feathers-hooks@1.8.1
│ │ │   │ ├── feathers-commons@0.8.7
│ │ │   │ ├─┬ feathers-hooks-common@2.0.3
│ │ │   │ │ ├── feathers-errors@2.5.0 deduped
├─┬ feathers-mongodb@3.0.0
│ ├── @feathersjs/commons@1.3.0 deduped
│ ├── @feathersjs/errors@3.2.0 deduped

NodeJS version:
v8.9.3
Operating System:
Linux x64 (AntergOS (Based on ArchLinux))

[daffl]

See feathersjs/feathers#757

[Buom01]

Thank you

[olaferlandsen]

See feathersjs/feathers#757

Hi @daffl, but I using mongoose and it still not work and the only option is create and using a hook before to convert plain object id(string) to ObjectId.