Need help to have a special user list

[ziryukochi]

Hello,

I have a table Conversations whit messages (list of Messages) :

Members : (list of users)

groupeName type text

In messages table :

I need to retrieve the list of users who haven’t read the message from the Conversation with conversation => groupeName = ‘test’

can someone help me please