Forum Discussion

shayl's avatar
shayl
Ace
4 years ago

Select messages containing video by LiQL query

How to select messages containing video by LiQL query?
  • shayl's avatar
    shayl
    4 years ago

    The answer has been found:

    SELECT id, view_href, subject, videos, videos.count(*) FROM messages WHERE videos.count(*) > 0
shayl's avatar
shayl
Ace
4 years ago

The answer has been found:

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