You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
$notInQuery, $dontSelect doesn't work with match in aggregate query #4842
I have one class in which I'm storing user details. In other class I'm storing the messages which is sent and received by the user and every row in the message class has a pointer which points to the receiverId user.
I'm using aggregate to get the unique receiver ids in the message class. For that I'm using some condition that has to satisfy in that corresponding user row.
For e.g.,
Message table has columns userId, receiverId, userData(pointer points to the user data of receiverId), etc.,
User table has columns userId, List1, List2, etc.,
Using aggregate, I'm trying to get the unique values of receiverId in which the given userId must not be in the List1 of receiverId's row.
Activity
flovilmart commentedon Jun 28, 2018
@dplewis I'm not sure we should supprot those nested operators at the moment right? Any way we can support them moving forward?
dplewis commentedon Jun 30, 2018
@newdev7 I can tell from this line here
"$notInQuery":{"where":{"List1":"abcde_12345"}}whereand$notInQuerydoesn't exist in the aggregate pipeline.You should use the standard rest api query constraints for this.
http://docs.parseplatform.org/rest/guide/#query-constraints
I believe there is a way to do this with aggregates.
newdev7 commentedon Jul 2, 2018
Hi @dplewis
I tried the aggregate pipeline operators like $cmp, $cond in rest api query. But it returned "Internal server error". I'm using MongoDB version 3.4
Could you please suggest me something to get that working with aggregates.