is Parse Query Constraints not supported ?

[anwar-al-jahwari]

Hello ,

I have successfully migrate the database to mongodb and i uploaded parse server to google app engine , i tried to query a class called Category
it worked.However , when i try to do some Constrains like where equal to it didn't work.

the rest api ,shows the same result with or without constrains

in addition i have tried the same thing in android sdks and it didn't work when i put constrains only it works without the constrains.

[armenkh]

I have similar problems.
Query with constrains returns all the elements of the Item, I reported in the for mum also:
https://groups.google.com/forum/#!topic/parse-developers/rPxdWUNSagI

Doesn't properly work with Android SDK eather:
http://stackoverflow.com/questions/35154414/parse-getinbackground-throws-invalidkeyname-exception

[rmistry75]

Same problem here. Whenever I try to query (via REST API) using a "where" clause, the clause is ignored and instead I get ALL items of that class.

[gfosco]

Ok, this is not supposed to be the case, obviously. Must be some difference from the various test scenarios we have. Will look at it very soon.

[bodhaguru]

Same problem for me too - when using REST API. It is giving error on line 83 in node_modules/parse-server/node_modules/body-parser/lib/types/json.js file - saying "Unexpected token ....". It is expecting only "{" or "[" there, whereas what is getting passed is "w" or "u" depending upon the query.

[petek157]

I am having this issue as well. I see there are a number of "issues" regarding this topic but it doesn't seem as though any of them have resolved. I have tried using REST, PHP and JS and its seems like none are adhering to constraints. I apologize that I can't elaborate like others as I used Parse because Im not as advanced in programming to build this out my self. My issue seem like above that no matter what constraints I put on a query I get all objects in that class.

<?php

use Parse\ParseClient;
use Parse\ParseCloud;
use Parse\ParseObject;
use Parse\ParseQuery;
use Parse\ParseFile;
use Parse\ParseUser;
ParseClient::initialize('APPID', 'REST', 'MASTER');
ParseClient::setServerURL('http://URL:1377/parse');

$query = new ParseQuery("Product");

$query->equalTo("length", 9);
$object = $query->first();
echo $object->getObjectId();
?>

//Returns wrong objectId
//Assuming its just the "first" object returned

Parse.initialize("APPID", "JSKEY");
    Parse.serverURL = 'http://URL:1377/parse';

    var Product = Parse.Object.extend("Product");
    var query = new Parse.Query(Product);
    //query.equalTo("length", 9);
    query.find({
      success: function(product) {
        // The object was retrieved successfully.
        console.log("Color: " + product[0].get("visualColor"));
        console.log("ID: " + product[0].id);
      },
      error: function(object, error) {
        // The object was not retrieved successfully.
        // error is a Parse.Error with an error code and message.
      }
    });

Logs blank and the incorrect id
again assuming its just the first object returned.
checking the count 5 objects are returned which is all of them and only 1 has the length of 9

curl -X GET \
>   -H "X-Parse-Application-Id: APPID" \
>   -H "X-Parse-Rest-API-Key: RESTKEY" \
>   -G \
>   --data-urlencode 'where={"objectId":"kVzk5HYB9k"}' \
>   http://URL:1377/parse/classes/Product

Curl returns list of all objects

[nlutsenko]

Looks like we don't handle url queries in Classes to be passed as non-body parameters, this is definetly a bug, but for now as a workaround - use JSON body with method: GET inside of it.

[rmistry75]

Hi, I'm not sure what the "workaround - use JSON body with method: GET inside of it." means. Can you please show us how to implement the workaround with an example. Perhaps you can show us how to fix the example listed above:

curl -X GET \

-H "X-Parse-Application-Id: APPID"
-H "X-Parse-Rest-API-Key: RESTKEY"
-G
--data-urlencode 'where={"objectId":"kVzk5HYB9k"}'
http://URL:1377/parse/classes/Product

What would the workaround solution look like for this curl request?

Thanks!

[marcinwalus]

Hi!
I just migrated app from Parse.com to Azure Managed services. I have everything working correctly (parse dashboard, etc.). Except this issue with "Query Constraints".
From my Mac app when I ask for specific object in class with given "objectId" I'm getting all objects in class in return and not one specific. In Api Console in my parse dashboard I'm getting specific object correctly.
@nlutsenko Is this issue fixed?

[flovilmart]

@marcinwalus can you run parse server with VERBOSE=1 set and provide the server logs please?

[marcinwalus]

This is the query

let query = PFQuery(className: "Location")
query.whereKey("objectId", equalTo: locationObjectId)
query.includeKey("organization,city,city.country,city.country.language")