Whatsapp like chat list with last message

I have a message node where I save messages form my users. Now I need to create an summary view like whats app where it shows all the chat list with last message. I have no Idea where to start from. Can someone please help me with some example or query Please.

this is my node input

{ "from" : "1", "to" : "2", "post_date" : "2017-06-4T14:12:12", "message" : "trying out Elasticsearch", "seen":0 }

the output I want is

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.