parse.com cloudcode query, how to tell parse to return only certain columns of a PFObject found in a table?

Question

I have this function on parse cloudcode:

Parse.Cloud.define("testfunction", function(request, response) {

    var username = request.params.username
    var testObject = Parse.Object.extend('Test');
    var query = new Parse.Query(testObject);
    query.equalTo('username', username);
    // PFObject "Test" in the table has columns A,B and C
    // how do I tell the query that in the final result I send back 
    // in the response I only want filed A?

    query.find({
        success:function(results) {
            response.success(results)
        },
        error:function() {
            response.error('Could not find channels')
        }
    })
});

I am not sure how to tell the query to only return filed A and not field B and C as part of any of the PFObjects that come back from the query?

thank you

Björn Kaiser · Accepted Answer · 2014-08-31 10:19:28Z

6

You can use the select method of the query to limit the fields that will be returned.

var username = request.params.username
var testObject = Parse.Object.extend('Test');
var query = new Parse.Query(testObject);
query.select('A');
query.equalTo('username', username);

It is a bit hidden in the documentation but you will find it in the Query Constraints section of the JavaScript Guide [1] (you will have to scroll down a bit there to find it).

[1] https://parse.com/docs/js_guide#queries-constraints

answered Aug 31, 2014 at 10:19

Björn Kaiser

9,9024 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

zumzum Over a year ago

ok, so, that almost works. Meaning, I went in and entered the three fields of the PFObject stored in the table I wanted to get. They come back fine. No matter what I do though it seems like "objectId", "createdAt", "updatedAt" and "__type" always get returned. Does that mean I cannot filter those out from the response?

Björn Kaiser Over a year ago

I can't prove this now, but I would assume that, as these fields are 'core fields' on Parse, they will always be returned when you query information. What you could do is just returning a new object that just has the property of field A. So you wouldn't actually return the queried object 1:1 but only take out the information you need.

jiawen Over a year ago

is there a way to exclude a field?

Collectives™ on Stack Overflow

parse.com cloudcode query, how to tell parse to return only certain columns of a PFObject found in a table?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related