I'm trying to get back only what the user owns in an object. More specifically only the review that the user wrote.
The reviews object is inside of my summaries table. The information of every record in the summaries table is the same for everyone except the reviews. So think of it as maybe different dishes on a restaurant which is the same for everyone but different users have written different reviews for that same dish, and the user can only see their review. So I figured creating an object for the reviews with a table reference to my reviews table would be a good idea.
As you can see here the reviews are linked to a user.
Every user also has their reviews linked.
So I'm just wondering how you would make it so the user only sees their review from the reviews object.
I have been told that custom queries is the way to go but that only works with query all records and not when getting a single record right?
So I did a precondition here in the reviews table first to make sure the correct user is the only one to access their review and for some reason that doesn't work.
Here is a more detailed picture.
I did the same thing in the summaries table and that also doesn't work.
Thankful for answers!