Ability to query nested documents/objects/arrays

[faridnsh]

For example right now there doesn't seem to be an easy way to have equivalent of this mongodb query with loopback where filters:

{
    people : {
        $elemMatch : {
            id : ObjectId('546047f6118d30f014000001'),
            tags : { $in : ['alive'], $ne : 'rich' }
        }
    }
}

Do note that poeple is an array of objects that contains, tags which is an array of strings.

Note that this has been asked before on mailing list and on stackoverflow.

[fabien]

With the PR in place, the above query should work as follows:

{
    people : {
        elemMatch : {
            id : '546047f6118d30f014000001',
            tags : { in : ['alive'], ne : 'rich' }
        }
    }
}

It might have worked before, but not if you defined the people property as:

people: { type: [Person] }

[bajtos]

This is possibly a duplicate of #517.

[arealmaas]

+1 for support in the memory-connector aswell!

[kennethlynne]

Yeah what @AlmaasAre said!

For testing purposes

[eugenehp]

hey @bajtos can you advise what is the best place in source code to start tickling this feature?
I saw 6+ months of support at #517 and looks like I'm going to need this in couple of my productions...

so what would be your advise to implement this so it might get a chance to be merged to master branch.

Thanks. 👍

[bajtos]

@eugenehp

can you advise what is the best place in source code to start tickling this feature?
I saw 6+ months of support at #517 and looks like I'm going to need this in couple of my productions...

so what would be your advise to implement this so it might get a chance to be merged to master branch

@raymondfeng @fabien do you have any thoughts on how to implement support for querying nested documents/objects/arrays? I am not familiar enough with this part of loopback to give a good advice.

[eugenehp]

thanks @bajtos
I'm particularly going to be interested to implement solution on top of the mongodb connector first, and then possibly MySQL.

Since you guys @raymondfeng @fabien have more experience with your code, please advise on the best way to pursue this.

Thank you.

Have a nice weekend ahead!

[pthieu]

@eugenehp: Have you made any progress on this: https://github.com/strongloop/loopback-datasource-juggler/pull/1083/files allows this functionality but only for arrays and may provide some insight on now to implement for objects.

There's also #517, which is an ongoing discussion on filtering level 2 properties. Will close this issue if no response since it's been over a year.

[loay]

@eugenehp Nested query is currently working with Mongodb. Please have a look at it.
I am closing this issue in favor of #517