Some Loopback endpoints are ignoring dates - and it's infuriating!

[cliff....@tpv-tech.com]

Hi there - we're using the following:

• Loopback 3.0 (with the Postgresql connector)
  
• Node v6.12.3
  

..and an Angular front end.

I'm trying to retrieve both the count of records between two dates and the records that also fall between these dates.

If I call* the API 'count' endpoint with this URL:

• http://127.0.0.1:3000/backend/api/sasdevices/count?where[first_conn][between][0]=2018-04-01&where[first_conn][between][1]=2018-04-09
  

..I get a count of the items within that date range and I see this in the debug console:

• loopback:connector:postgresql SQL: SELECT count(*) as "cnt" FROM "public"."sasdevices" WHERE "first_conn" BETWEEN $1 AND $2
  
• loopback:connector:postgresql Parameters: ["2018-04-01","2018-04-09"] 
  

And I get a valid count of the records between those dates, which is everything I would expect.

However, if I call the 'find' endpoint with the same parameters, like either of these:

• http://127.0.0.1:3000/backend/api/sasdevices?where[first_conn][between][0]=2018-04-01&where[first_conn][between][1]=2018-04-09
  
• http://127.0.0.1:3000/backend/api/sasdevices?filter[first_conn][between][0]=2018-04-01&filter[first_conn][between][1]=2018-04-09
  

..then the debug console shows this:

• loopback:connector:postgresql SQL: SELECT (list of fields) FROM "public"."sasdevices" ORDER BY "deviceid" 
  

...and then tries to return all 2 million+ records, crashing the server. Less than ideal.

I've also tried the JSON formatted requests from Postman and discovered that while this doesn't work:

• http://127.0.0.1:3000/backend/api/sasdevices?filter={"first_conn":{"between":["2018-03-19","2018-03-20"]}}
  

..this request does:

• http://127.0.0.1:3000/backend/api/sasdevices?filter={"where": {"first_conn": {"between": ["2018-03-19","2018-03-20"]}}} 
  

But if I add the '["where":' to the request in the code, I get an error that the dates could not be processed.

Why is the 'find' endpoint not honouring the dates provided? 

(* Doesn't matter if I use code, the Loopback API Explorer or Postman, the results are the same.)

[Mark Johnson]

It looks like it's not working because you're not nesting "where" inside "filter" for find.  where is only a top level property for count because the filter properties are otherwise useless.

So you need filter[where][...]..