Forum Discussion

cike's avatar
cike
Champion
9 years ago

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...
Claudius's avatar
Claudius
Boss
9 years ago
Applying the topic message filter and-connected to the date time and tag filter works for me. I assume the problem in your community might be related to your tag-problem discussed in https://community.lithium.com/t5/Support-Forum/Error-using-LIQL-query-like-quot-tags-text-test-quot-or-quot/m-p/215814#M10315 ?

But just to double check I understood your query correctly:
You are looking for all topic starting messages, that were tagged with a certain tag. NB: The tag has to be applied to the topic starting message. The filter won't match if the tag was applied to a reply within that topic.
  • cike's avatar
    cike
    Champion
    9 years ago

    Claudius You are right.

     

    The result list should only contain topic starting messages that were tagged with a certain tag. If I start a new topic and tag it with a certain tag, the filter will return this new topic. But if I reply to an existing topic (where the topic starting message is tagged) this topic is not returned by my query. The conversation.last_post_time is set correctly.