doesNotMatchKey not working

[dasoga]

Hi!

I'm trying to do this query on my own hosted Parse server but I get error con shell:
Code:
- (PFQuery *)queryForTable { PFQuery *bann = [PFQuery queryWithClassName:@"Banned"]; PFQuery *query = [PFQuery queryWithClassName:self.parseClassName]; query.cachePolicy = kPFCachePolicyCacheThenNetwork; query.cachePolicy = kPFCachePolicyNetworkElseCache; [query whereKey:@"qUser" doesNotMatchKey:@"bannedUser" inQuery:bann]; [query orderByAscending:@"createAt"]; return query; }

Get on shell:
*[Error]: improper usage of $dontSelect (Code: 102, Version: 1.12.0) *

Thanks For help.

[nlutsenko]

Hey @dasoga, sounds very strange, as this should work...
Let's debug this together, here are few questions that would help:

• Are you using parse.com or self-hosted Parse Server?
• What does your object schema look like for both Banned and the objects you are querying for (can't see the class name).
• Could you instrument your app with Network Debug Tool from this guide. The most important piece is how the query is being sent to the server...
• Does this reproduce if you are issuing a cURL request with the same data?

Confident we can uncover the problem together...

[parse-github-bot]

Thank you for your feedback. We prioritize issues that have clear and concise repro steps. Please see our Bug Reporting Guidelines about what information should be added to this issue.

Please try the latest SDK. Our release notes have details about what issues were fixed in each release.

In addition, you might find the following resources helpful:

• Documentation: https://www.parse.com/docs
• Google Groups: https://groups.google.com/forum/#!forum/parse-developers
• Stack Overflow: http://stackoverflow.com/tags/parse.com

[dasoga]

Hi @nlutsenko

• Are you using parse.com or self-hosted Parse Server?

self-hosted Parse Server

• What does your object schema look like for both Banned and the objects you are querying for (can't see the class name).
  I have the class "Question" (questions uploaded for users) and class "Banned" (for users banned). And I want to do a query for question without user banned.
• Could you instrument your app with Network Debug Tool from this guide. The most important piece is how the query is being sent to the server...

Request Body : {"where":{"qUser":{"$dontSelect":{"query":{"className":"Banned"},"key":"bannedUser"}}},"order":"createAt","_method":"GET","limit":"10"} 2016-03-08 18:07:16.600 alertatrasero[14595:6171749] [Error]: improper usage of $dontSelect (Code: 102, Version: 1.12.0) 2016-03-08 18:07:16.600 alertatrasero[14595:6171750] URL : http://184.171.252.178:1337/parse/classes/Question 2016-03-08 18:07:16.601 alertatrasero[14595:6171750] Status Code : 400 2016-03-08 18:07:16.601 alertatrasero[14595:6171750] Headers : { "Access-Control-Allow-Headers" = "X-Parse-REST-API-Key, X-Parse-Javascript-Key, X-Parse-Application-Id, X-Parse-Client-Version, X-Parse-Session-Token, X-Requested-With, X-Parse-Revocable-Session, Content-Type"; "Access-Control-Allow-Methods" = "GET,PUT,POST,DELETE,OPTIONS"; "Access-Control-Allow-Origin" = "*"; Connection = "keep-alive"; "Content-Length" = 52; "Content-Type" = "application/json"; Date = "Wed, 09 Mar 2016 00:07:11 GMT"; Etag = "\"1510158381\""; "X-Powered-By" = Express; }

• Does this reproduce if you are issuing a cURL request with the same data?

When I do a CURL to get the objects of Banned class everything is correct, same to the Question class. I don't know how can I do CURL with "doesNotMatchKey" parameter.

Thanks for response!

[nlutsenko]

I think I've found the issue - this is the relevant piece of code that gets triggered.

I am going to double check whether removing a !query.where is going to impact anything, but I think that's the fix... Overall, as a workaround - add any condition to your banned query and it should start working.

[dasoga]

Excellent work @nlutsenko I added any condition to Banned query and it works!
For this moment I'll keep this query this way
Thanks a lot for your help.