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