Forum Discussion

Inactive User

7 years ago

SELECT cover photo using LiQL

How can I SELECT the cover photo using LiQL? SELECT * FROM images WHERE messages.id = '740' Gives me the two images for this post; one is in the body, the other is the cover but there's no appar...

TariqHussain
7 years ago
Inactive User - You can achieve this using below query.

SELECT cover_image from messages where id = '<message.id>'

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages

TariqHussain

Boss

7 years ago

Inactive User - You can achieve this using below query.

SELECT cover_image from messages where id = '<message.id>'

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages

Inactive User
7 years ago
Thanks!
Inactive User
7 years ago
I see, so if I'm more specific in my messages query, I can do this, i.e.,

SELECT id,subject,body,cover_image FROM messages WHERE board.id = 'someboard'

Forum Discussion

SELECT cover photo using LiQL

Related Content

Select messages containing video by LiQL query

Can we use Select statement as UserCache Key

Select Kudos with message query

Select * from Categories (returns 0 categories 🤔)

Get cover image using API V1?

Recent Discussions

API v1 docs gone since Atlas migration to Aurora

Does anyone know how to change the display title of Custom Fields in Aurora?

Can someone walk me through authenticating and using Postman with Aurora?

Seeking Advice on Restricting Access to a posts to those who have the permalink.

TinyMceEditor is undefined