where clause on 3 tables

Hi, I’m working on android. Actually, I want to retrieve data using where clause. I have a table “Posts” which has a one-one relation with BackendlessUser Class named “creator”, that creator object has a one-one relation with “Organization” table, Now I want to retrieve that posts for which creator’s organization’s name is same to the current user. Kindly help. waiting for your reply.

Hi Mubtada,
Try to use the where clause “creator.organization.name=’<%name%>’” in the request to the Posts table.

Regards Ilya