How to create this query in Parse cloud Javascript SDK?

Question

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

knshn · Accepted Answer · 2014-08-02 17:41:23Z

2

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) {

  }
});

answered Aug 2, 2014 at 17:41

knshn

3,4611 gold badge24 silver badges22 bronze badges

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

2 Comments

vishal dharankar Over a year ago

can you check the code i added ? it returns empty array even when there is reasonable data available in both tables

knshn Over a year ago

First try the genderQuery by itself and check if it returns any users. Then, try your scoreQuery with only find() to check if it returns any JournalEntry. Is it userName or username? Is it "User" or Parse.User?

Collectives™ on Stack Overflow

How to create this query in Parse cloud Javascript SDK?

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