CODEWITHSUNDEEP
javascriptiosparse-platform
vishal dharankar
vishal dharankar

Reputation: 7746

How to create this query in Parse cloud Javascript SDK?

I need to create / execute following SQL query in Parse Javascript SDK.

Select * form xyz table where xyz.username in [select username from users where gender = "male"];

Not able to figure out how to do this using Parse SDK , please help.

added code :

var gender = request.params.gender;
var users = [];
console.log(gender);
if(strcmp1(gender , "All") != 0)
{
    var genderQuery = new Parse.Query("User");
    genderQuery.equalTo("gender",gender);
    var scoreQuery = new Parse.Query("JournalEntry");

    scoreQuery.matchesKeyInQuery("userName", "username", genderQuery);
    scoreQuery.find({ 
        success: function(results) {
            for(j = 0; j < results.length ; j++)
            {
                var entry = results[j];
                users.push(entry.get("username"));
            }
            response.success(users);    
        }
    });
}

Thanks Vishal

Upvotes: 1

Views: 425

Answers (1)

knshn
knshn

Reputation: 3461

You can use matchesKeyInQuery

var maleQuery = new Parse.Query(Parse.User);
maleQuery.equalTo("gender", "male");

var xyzQuery = new Parse.Query("xyz");
xyzQuery.matchesKeyInQuery("username", "username", maleQuery);
xyzQuery.find({ 
  success: function(results) {

  }
});

Upvotes: 2

Related Questions