Backendless Support
 
Answered

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.

Leave a Comment

Comments (1)

photo
1

Hi Mubtada,

Try to use the where clause "creator.organization.name='<%name%>'" in the request to the Posts table.

Regards Ilya