Hello,
I have a conversations table with the related Messages table
but when I do :
I don’t have anything, but I do have a message with ‘ok’ in the database.
Any ideas why ? thx
The first thing I would check would be privacy rules. Do those look correct to you?
Hey @J805 , thx for the reply, that’s what I’ve put in place :
and that’s why I don’t have my message list.
But how do I set the privacy rules correctly ?
It looks like it isn’t a privacy rule issue that is causing it to not show up. You actually have it where it is not private at all. Anyone can view those fields. Just FYI, you may not want to have it set up that way.
Back to the issue at hand, does it show up without the constraint? Your screenshots are very cut off, so it’s hard to have a good look at it. 
Hey @J805 ,
It’s a privacy rule problem, when I delete the privacy rule I get my messages displayed.
Before :
i set it like that now :
I created test_visble :
I created test_visible , it’s the list of people in the conversation that can read the msg.
Now it works, but I still duplicate the data in the database between test_visble and the Members conversation table.
conversations table :
do you have any other solutions please?
Good job. 
You said it works now right? Is there still an issue then?
thx @J805 ,
Yes, it works, but it means that I have twice the list of conversation users in the database:
- in the conversation table (Members = list of users)
- in the messages table (test_visible = list of users)
I don’t find this very optimized , It also works if I put this privacy rule :
is this a good rule ?
I think you are close, but this is not really a good setup, see the error here:
It is sometimes best to duplicate data for the sake of privacy rules.
For example. If you were to have each company have their own private data on an app, each database thing would have to have the parent company attached to it to keep it private and to match up the correct data with the correct company.
Does that make sense? For your app, each message could have the list of users that can see that message for privacy rules to work properly. 
Hope that helps a bit.
Hey @J805 ;
Okay thanks for the explanation i’ll go back to adding a ‘visible’ column with the list of users who can see the msg.
1 Like