loopback Find() "where" clause not returning expected results

Question

I am using loopback to serve the API for my application and I tried to change the GET request for some data.

As of now the query fetches all the results for a particular API:

People.find({
    where: {
      'town': 'name of a town'
    }
  }).$promise
  // Promise is fulfilled and people returned
  .then(function(results) {
    $scope.people = results;
  })
  // Promise is rejected and error catched
  .catch(function(err) {
    $scope.errors.PeopleFind = JSON.stringify(err.data.error.message ?
      err.data.error.message :
      err.data.error.errmsg
    );
  });

I already tried with adding single quotes to the where clause or to do something like .find({ where : { town : 'name of a town' }}.

No matter where I put the quotes the results are always the whole package. How would I query for just the results that I'm interested in?

Thanks in advance

This is done in the front-end with already programmed endpoint and hooks. — 404answernotfound, Mar 09 '17 at 07:46

score 11 · Accepted Answer · answered Mar 09 '17 at 08:30

I found the answer thanks to a collegue, I'll write here the answer

People
            .find({
                filter: {
                    where: {Town : currentUserTown}
                }
            })

The documentation for the loopback framework did not state that you needed to apply a filter object to actually filter the results, in fact you can check the documentation with this example they wrote:

Cars.find({where: {carClass:'fullsize'}});

Before the where clause object you need to write the filter object that contains the clause, that should solve the problem with the query.

score 3 · Answer 2 · answered Apr 10 '18 at 11:54

3

use like like this:

People.find({where: {Town : like: {currentUserTown}}}, function(err, res){
//code goes here.
})

and be sure you've added strictObjectIDCoercion in json file:

{
  "name": "People",
  "base": "PersistedModel",
  "idInjection": true,
  "options": {
    "validateUpsert": true,
    "strictObjectIDCoercion": true
  },
  "properties": {
 // rest of json file ...

hope this helps.

answered Apr 10 '18 at 11:54

Ali Bahrami

910
9
21

Thanks Ali Bahrami. Your answer helped me a lot. – Henok Tesfaye Oct 05 '18 at 07:23

score 0 · Answer 3 · answered Jan 09 '20 at 04:37

0

This is the common mistake, please check your respective model People.json config file, and make town: {"type":"string"}

answered Jan 09 '20 at 04:37

ritesh

177
2
4

loopback Find() "where" clause not returning expected results

3 Answers3