Fetch ParseObject data based on relations query

Question

I've question about way in which I should create query to get expected data.

I've MyObject (ParseObject) which has pointer to ParseUser (column named createdByPtr). In ParseUser I have custom column userGroupPtr.

Now I want to get all MyObject rows which are created by all users (createdByPtr) belongs to user group (userGroupPtr) to which belongs current logged user (ParseUser.CurrentUser()). At this moment I have some kind of draft like this:

ParseQuery<MyObject> query = ParseQuery.getQuery(MyObject.class);
        query.include("createdByPtr");
        query.whereEqualTo("createdByPtr.userGroupPtr", ParseUser.getCurrentUser().get("userGroupPtr"));
        query.orderByDescending("updatedAt");
        query.findInBackground(new FindCallback<MyObject>() {
            @Override
            public void done(List<MyObject> results, ParseException e) {
                ....
            }
        });

I don't have idea how should I transform line:

query.whereEqualTo("createdByPtr.userGroupPtr", ParseUser.getCurrentUser().get("userGroupPtr"));

in to working constrain.

Any suggestions?

see my edited anwser.!

Kishore Jethava
– Kishore Jethava

2015-10-16 11:40:10 +00:00
Commented Oct 16, 2015 at 11:40 — Kishore Jethava
– Kishore Jethava, Commented Oct 16, 2015 at 11:40

Kishore Jethava · Accepted Answer · 2015-10-16 11:53:28Z

1

Try like this. I have tested and it works perfectly. see Relational Queries

 ParseQuery<ParseUser> innerQuery = ParseUser.getQuery();
    innerQuery.whereEqualTo("userGroupPtr","userGroupPtr"); //value of userGroupPtr
    ParseQuery<ParseObject> query = ParseQuery.getQuery(MyObject.class);
    query.whereMatchesQuery("createdByPtr", innerQuery);
    query.findInBackground(new FindCallback<ParseObject>() {
      public void done(List<ParseObject> objectList, ParseException e) {

          if(e == null){

          }else{
              Log.e("Object", e.getMessage());
          }
      }
    });

edited Oct 16, 2015 at 11:53

answered Oct 16, 2015 at 10:04

Kishore Jethava

6,8545 gold badges39 silver badges54 bronze badges

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

1 Comment

Gie Over a year ago

Unfortunately it doesn't work. In result list I don't have any items. I'm not sure if this constrain "MyObject.ColumnPtr" is valid in Parse. I included it in my main query as example to what I want to get.

Collectives™ on Stack Overflow

Fetch ParseObject data based on relations query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related