Forum Discussion

Ace

4 years ago

Select messages containing video by LiQL query

How to select messages containing video by LiQL query?

4 years ago

The answer has been found:

SELECT id, view_href, subject, videos, videos.count(*) FROM messages WHERE videos.count(*) > 0

Ace

4 years ago

The answer has been found:

SELECT id, view_href, subject, videos, videos.count(*) FROM messages WHERE videos.count(*) > 0