Parse PHP - Query on Relation class

Question

I'm currently using the PHP library of Parse SDK and i would like to do an equalTo query on the relation object of a row.

Basically, get all the Lines where relation class LineData column 'status' = 1.

Does anyone have any idea on how to achieve this? I can't find anything in the official docs or a google search.

$query = new ParseQuery("Lines");
$innerQuery = $query->get("LineData")->getQuery()->find();

$innerQuery->equalTo("status", ['__type' => "Pointer", 'className'=> "States", 'objectId' => "XvGh5HkSAw"]);
$results = $innerQuery->find();
return $results;

Any help would be greatly appreciated. Thanks

shayegh · Accepted Answer · 2017-09-14 18:11:31Z

1

use getRelation() on relation columns, not get()

$user = ParseUser::getCurrentUser();
$relation = $user->getRelation("likes");
$query = $relation->getQuery();
$query->equalTo("title", "I'm Hungry");
$postsLiked = $query->find();

http://docs.parseplatform.org/php/guide/#many-to-many-relationships

answered Sep 14, 2017 at 18:11

shayegh

3321 silver badge10 bronze badges

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

Comments

tutchmedia · Accepted Answer · 2017-09-15 08:05:53Z

0

I managed to figure this out myself. Seems we have to do a a query on the child class and then match that query with the parent class.

$innerQuery = new ParseQuery("LineData");
$innerQuery->equalTo("Status", ['__type' => "Pointer", 'className'=> "States", 'objectId' => "XvGh5HkSAw"]);

$query = new ParseQuery("Lines");
$query->matchesQuery("InnerLine", $innerQuery);
$all = $query->find();

Hope it helps anyone.

answered Sep 15, 2017 at 8:05

tutchmedia

1392 silver badges12 bronze badges

Collectives™ on Stack Overflow

Parse PHP - Query on Relation class

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related