Parse.com Multiple Count Queries in one Call

Question

I am using parse.com for my app for data storage etc... I have a quick question, when the user opens my app they are directed to their dashboard, in their dashboard there is a pie chart displaying data. I have in parse a class, in which a colour is an attribute, there are 6 different colours.

I want to display the colour values in the pie chart i.e. 6 red, 3 yellow, 2 blue etc. I researched this through google and came up with this https://www.parse.com/questions/can-i-manage-multiple-count-queries-in-a-single-call which states that it's not possible to have multiple count queries in a single call, however, this was posted 2 years ago and I'm wondering a. if there's been any advances on this since and b. if not what is the best way to go about this.

If I make 6 different calls, and I have to wait until I get the call back from the sixth count query before displaying the pie chart then there could be some delays which isn't good for user experience.

If anyone has any tips on this I'd appreciate it

ryanjduffy · Accepted Answer · 2014-07-02 12:14:32Z

7

I'd recommend creating a Cloud Code Function to query the counts in parallel and return the results in one response. I've used that successfully on a project using Parse.

Something like this:

Parse.Cloud.define("dashboard", function(request, response) {
    // create each query and start it
    var red = new Parse.Query("A").equalTo("colour", "red").count();
    var blue = new Parse.Query("A").equalTo("colour", "blue").count();

    // wait for them all to complete using Parse.Promise.when()
    // result order will match the order passed to when()
    Parse.Promise.when(red, blue).then(function(countOfRed, countOfBlue) {
        response.success({
            red: countOfRed,
            blue: countOfBlue
        });
    });
});

edited Jul 2, 2014 at 12:14

answered Jul 1, 2014 at 13:43

ryanjduffy

5,2353 gold badges24 silver badges13 bronze badges

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

2 Comments

DJ-DOO Over a year ago

thanks for your reply. I'm sorry I'm not following 100%. I have table/class 'A' in which I have a column colour and I want to get a total of each colour. Would you mind explaining a little further..it would be appreciated.

DJ-DOO Over a year ago

sorry to continue this but if I wanted to filter this based on the current user? Normally it would be query.equalTo("userId", userid); but with this promise I'm unsure.

Collectives™ on Stack Overflow

Parse.com Multiple Count Queries in one Call

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related