Limit filter on included models results in unexpected output

[achintverma]

Assume there are two models Account and Listing. I want to pull accounts with 5 listings from each account. When make a REST call as follows:

Account.find({
     where:{
        state: 'CA'
      },
      include: {
         relation: 'listing',
         scope:{
           limit: 5
         }
     }
});

It gives result with No Listings in few accounts but in reality there are listings under each user

[achintverma]

BTW, connector is MongoDB

[ron137]

+1

[jannyHou]

@achintverma @ron137 Can you fork https://github.com/strongloop/loopback-sandbox and replace it with your code?

result with No Listings in few accounts

This makes it hard for me to reproduce your problem if it doesn't happen in all instances. Thanks.

[loay]

Hi @achintverma Can you please provide a sample repo so we can debug the issue? Thanks.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale[bot]]

This issue has been closed due to continued inactivity. Thank you for your understanding. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository.

[achintverma]

Apologies for the late response. For some reason, I didn't get any email notification for all other activities except the closure today.