What is the best way to get the first message from a chat?

[guirms]

I know about the route /api/:session/chats/:chatId/messages, but this route doens't have a parameter for ordering, wich means that I need to get all messages and then filter for the first one mannually. Is there a better way to do this?

[devlikepro]

https://waha.devlike.pro/docs/how-to/chats/#get-chats-overview with limit=1 and ids={chatId} set probably could work

[devlikepro]

oh wait, do you need THE FIRST message in the chat?
A bit surprising request :)

Probabably we could get sort option in messages, but it'd work good in NOWEB/GOWS engine only, WEBJS doesn't expose proper database layer.
What engine do you use?

[guirms]

Yep, I need the first message because I need to know who has started the chat, the agent AI or me. I'm doing this by reading the first message and checking if it is equal to the message setted in the agent AI prompt.

I use the GOWS engine.

[devlikepro]

Save some flag in database and use it. History becomes unavailable in connected devices in few months