How To Get Random Rows(parse Objects) From Parse Table Using Android Parse Sdk?

I have 500 records on parse class or table and now i need to get 10 random records out of 500 records? Please tell me how can I do this. ParseQuery query = Pars

Solution 1:

The best way is probably to write a CloudCode module that downloads 500 objects, then randomly selects 10 to send down to your Android app in the response. That's much better than downloading 500 objects to your device and choosing 10.

It's been a while since I've written CloudCode, but you could do something like the following.

in iOS app (you can do a little work to find the Android equivalent):

[PFCloud callFunctionInBackground:@"get500obj" withParameters:@{} block:^(id result, NSError *error) {
   // do something with result
}];

in CloudCode (this should be treated as pseudocode as it's untested):

Parse.Cloud.define('get500obj', function(request, response) {
    // for getting random elementArray.prototype.randomElement = function () {
        returnthis[Math.floor(Math.random() * this.length)]
    }

    var query = newParse.Query("your-object-class-name");
    query.find({
        success: function(results) {
            var final10 = [];
            for (var i = 0; i < 10; i++) {
                var myRandomElement = results.randomElement()
                if (final10.indexOf(myRandomElement) == -1) {
                    final10.push(myRandomElement);
                } else {
                    i--;
                }
            }
            response.success(final10);
        },
        error: function() {
            response.error(error);
        }
    });
});

Solution 2:

Here is an Objective C code sample.

PFQuery *query = [PFQuery queryWithClassName:@"MyTable"];
int count = [query countObjects];

int r = arc4random_uniform(count);

PFQuery *query2 = [PFQuery queryWithClassName:@"MyTable"];
query2.skip = r;

PFObject *result= [query2 getFirstObject];

`

Solution 3:

This is working code for fetching random objects from given class in Parse

In cloud code,

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

query = newParse.Query(request.params.movie);

Array.prototype.randomElement = function (min, max) {
returnMath.floor(Math.random() * (max - min + 1)) + min;
}


query.find ({

success: function(results) {

        var final10 = [];

        for (var i = 0; i < 5; i++) {
            var myRandomElement = results.randomElement(0,results.length);

            if (final10.indexOf(myRandomElement) == -1) {
                final10.push(myRandomElement);
            } else {
                i--;
            }
        }
         var datalist =[];

        for(var j=0;j<final10.length;j++)
        {
            var index= final10[j];
            datalist.push(results[index]);
        }   

        response.success(datalist);
    },
    error: function() {
        response.error(error);
      }
    });
  });

In Android,

HashMap<String, Object> params = newHashMap<String, Object>();
    params.put("movie", "The Matrix");

    ParseCloud.callFunctionInBackground("averageStars", params, newFunctionCallback<ParseObject>() {
      voiddone(ParseObject ratings, ParseException e) {
       if (e == null) {
          // Do your stuff
          }
      }
   });

Thanks to st.derrick for biggest hint.