cike
9 years agoChampion
Empty result list using date range on consversation.last_post_time
Hi,
im trying to filter my messages with the following query:
SELECT count(*) FROM messages WHERE depth = 0 AND conversation.style IN ('forum', 'group') AND tags.text MATCHES ('Zugangstechnik') AND conversation.last_post_time > 1454167508396 AND conversation.last_post_time < 1456845908396
The query should return all messages, where the last post time is within the last 30 days and today.
The count value is always 0, but the last post within this converstion was made on 2016-02-29.
If I remove the lower date range and send the query again, I get all messages until today.
SELECT count(*) FROM messages WHERE depth = 0 AND conversation.style IN ('forum', 'group') AND tags.text MATCHES ('Zugangstechnik') AND conversation.last_post_time < 1456845908396
For another use case I use a similiar query, but don't filter by a specific tag. This query also returns a correct result list
Could somebody help?
Thanks and kind regards,
Christian