Find out specific data for messages using API (LIQL)

Hello,

we are trying to figure out a high performant way to fetch all messages in the last x days.

LIQL comes in mind as we don't need many fields:

SELECT subject, ... FROM messages WHERE depth = 0

The issue we are struggling with is, that we need the following information:

- Solved Time: Date when the conversation was marked as solved.

- Last answered by: User who created the last answer in the conversation. We can get date by conversation.last_post_time but not the user

- First Response Time: Date of the first reply.

We could fetch ALL messages, group them by conversation id, order them by post time and calculate these information ourselves - but this sounds like A LOT of wasted data transferred - we would have to fetch almost 5x the data.

We already searched through the documentation.

Our ideal way of doing this would be to:

- Have these fields available at the conversation object

- Have the conversation object fetchable

- Overall give the conversation object more meaning: E.g.: Give the conversation object the subject of the first message, a board assignment, etc.