Specified Entity: Promo[mallId] is not related to lowerLevelEntity: Promo Error code:1017

Data Service
1

how to get a data where mallId = ‘M014’ ?
i try this code :
$data_query = new BackendlessDataQuery();
$condition = “Promo[mallId].objectId = ‘M014’”;
$data_query->setWhereClause( $condition );
$result = Backendless::$Persistence->of( “Promo” )->find( $data_query );but got an error : Backendless API return error: Invalid where clause. Specified Entity: Promo[mallId] is not related to lowerLevelEntity: Promo Error code:1017regards,Wendy

promo.png
promo.png1817×693 55 KB

2

Hi Wendy,
Provided that millId is the column in Promo table, you should use the following syntax:
$condition = “mallId.objectId = ‘M014’”;

3

hi Sergey,

thanks for the answer , its work perfectly now.

regards,
Wendy