Filter not working correctly

[sskhokhar]

Consider the following model definition:

Model A:

"properties": {
        "initiatorId": {
            "type": "any"   //ID of another model
        },
        "sharedUserId": {
            "type": "any"  //ID of another model
        }
    }

When I apply filter to model A in explorer like

{"where" : {"initiatorId" : "123123123"}}

I get the results but when I apply this filter

{"where" : {"sharedUserId" : "44553322"}}

I get empty array

Even this behavior is seen in filter like

{"where" : {"and" : [ {"initiatorId" : "123123123"},{"sharedUserId" : "44553322"}]}}

I get empty array.

I tried changing data types from "any" to "string" but still it doesn't work
Please suggest me something on this.

[sebastianfelipe]

What endpoint are you using this filter?

[sskhokhar]

Hi,
Sorry for late reply.
Actually this is happening almost on every endpoint and in every project I use loopback.
I dont know why this happens. I am not sure whether to use "String" or "Any" datatype to store MongoID.

[stale]

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.

[sunnyspan]

Got similar issue, when I use {"where":{"id":XX}} it returns the correct result.
But when I try other clause like ("where":{"itemId":AAA}} it returns empty array.
Further test the id clause with some invalid id i.e. {"where":{"id":YY}}, it incorrectly return an array of full result including all items.
I'm using loopback 3.8.0

[pradeep4sure]

Got similar issue, using orgId in Content as foreign key of id in Organisation collection. Using Content.find({where:{ orgId }}) returning [] empty array. Getting results when using other fields like Content.find({where:{ name }}).

[jasoncys]

Got similar issue. Here are the details:

• LoopBack version: 4.0.0 (generator-loopback@5.4.0 loopback-workspace@4.0.0)
• Node version: 8.9.1
• MongoDB version: 3.6.0
• Ubuntu version: 16.04 LTS
• ACL: Anyone can access to anything

Custom Participant model inherited from the built-in User with the following attributes:

    "user_type": {
      "type": "string",
      "required": true
    },
    "parentUserId": {
      "type": "string"
    }

where parentUserId is populated with User.id.

Receive empty array ([]) where queried using http://localhost:3000/api/Participants?filter={"where":{"parentUserId":"<id set by using User.id>"}}&access_token="<access_token>". No problem if "parentUserId" is replaced with "id" along with the corresponding id value.

If used with "WHERE" instead of "where", it returns all entities in Participants.

Please help. Thanks.

[obo20]

i'm receiving this exact issue as well. Has anybody found a way around this?

[jonathan-casarrubias]

I suddenly started to present this issue as well,

{"where": { "chainId": "598c71f8a61ed73d00756212"}}

it returns empty array :(. I believe this will be a datasource-juggler issue.

[sskhokhar]

The workaround to this problem is to use "Like" clause.
e.g

{"where" : {"chainId" : { "like" : "598c71f8a61ed73d00756212"}}}

I hope this helps you all.

[jasoncys]

@sskhokhar It works.

[sunnyspan]

Unfortunately the "like" clause workaround doesn't work in my case