Forum Discussion

cike's avatar
cike
Champion
10 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...
Views
Sign in to react to this post
Claudius's avatar
Claudius
Boss
10 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.
Sign in to react to this post
cike's avatar
cike
Champion
10 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.

Sign in to react to this post