Forum Discussion

Ace

5 years ago

Solved

Select messages containing video by LiQL query

How to select messages containing video by LiQL query?

5 years ago

The answer has been found:

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

Ace

5 years ago

The answer has been found:

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