Relationship Depth + Paging

REST
1

Dear Backendless,

I am trying to retrive some data from the relation paging api function - however i need it to a depth of 2. What is the best way to go about this as now autoload has been disabled?

Please assist me with this

All the best

2

Hi, @Anuj_Nayyar

We have relations depth in the Relations section. You can find it here
https://monosnap.com/direct/TQZDqchHrtNcsThA7itr4tst9Kfmx4

If you need to change Paging size you can do that in the Paging section.
https://monosnap.com/direct/wVEORUZ3XTDo4SaR1qrVv1AiL679aM
Regards,
Marina

3

Dear Marina, thank you for your quick reply,

Unfortunately when I do this - I get a __originSubID returned - not the data as expected.

Each user - has a relation field (1:N) - to chats - and each of these has a (1:N) relation field to the users in that chat.

What would be the most efficient way of retrieving the users chats and the users in that chat?

Thanks again

Anuj

4

Make sure that you add all related tables in the Relations field. Did you do that? If you need to retrieve the data for example, in the table A from related tables B and C. You need to select table B and C in the Relations.

image
image3152Ă—1446 282 KB

Regards,
Marina

5

Thank you very much for your reply Marina,

I was able to find a workaround - using a where clause.

Also is there a way to stop certain data items from being returned (for security reasons) - e.g. a users phone number - which I am using as an identifier.

6

You can prohibit reading/writing/updating/deleting some data using our Security system. You can read more about that here - https://backendless.com/docs/rest/data_security.html

Regards,
Marina

1 Like
7

Awesome thank you

8

I imagine you could also prevent certain data from being returned by using an “after” event handler to remove whatever you don’t want returned to the client?

9

Yes you are right.