Hi there,
I have a RG, type User, which lists some Chat Members just like Whatsapp. I also have a table with the type Messages. Now I want to sort the list of Users by the last message. How can I achieve this? I have already added a hidden field with the last message and its creation date. But I’m only able to sort the RG by the type User. Thank you very much for your help.
Cheers Marco
Hi Marco. My understanding is that you want to list users by the last message they created in a group conversation. The answer here depends on your data structure, but here’s how I would set it up:
Two data types: “Message” and “Conversation”. Every message has a “Conversation” field.
The RG’s data type should remain “Users”, but you should “do a search for” the “Message” data type. Filter Messages by a specific Conversation. Then Sort by “Created date” and set “Descending” to “yes”.
Now, select “each of” the search items’ “Creator”, followed by “:unique elements”, which will remove all the duplicate users if each user has sent more than one message.
Hope that helps!
1 Like
This topic was automatically closed after 70 days. New replies are no longer allowed.