fetch relational data

General
1

I have a table say “User” and in it I have a column “product” which is in relation with “Product” table. Now I want to fetch data of User1 along with its Product data in relation from the Product table??

2

Hi Vishal,

Please check the docs first and then narrow down your question if you have any difficulties with that.

3

See in my “Users” table I have one column that is in relation with Product table. Now when I call 1st User table and via it I call to retrieve Product detailsof the User using JavaScript, in the 1st call it exposes my whole User table data? How can I a logged in user gets only its product details?

4

You’ll need to add a where clause containing “objectId = <current-user-object-id>” to retrieve only logged in user.

5

Thank you for help.