I would like to pull via #REST_API all unanswered messages that are older than 24h (e.g. message post timestamp is older than 24h). Unfortunately the board message search does not really seem to offer such functionality:
Any alternative suggestions to achieve that?
Do I really have to manually compare timestamp with current time and omit all those that are too young?
Maybe LiQL allows for such magic?
I don't have the solution, but just a few thoughts.
1- In the Admin Metrics, you have 'Minutes to First Response'. I'm not sure where it comes from, but you might have a field tracking the first response time. If this is null, we can assume there was no response. And if you can do a diff between now and the timestamp of the post, and it's greater thean 1440 minutes, you will get what you want. I hope!
2- Another way, depending on what you're trying to achieve, would be to use the escalation. you set the value to 1440 (24 hours), and when a topic is unanswered within that time, it will be escalated by email to the email you've specified.
