Forum Discussion

steffenschoene's avatar
steffenschoene
Expert
6 years ago

Filter Messages by conversation/thread id

Hi, is it possible to filter messages by its conversation.id? The following APIv2 Call dose not work: SELECT * FROM messages WHERE conversation.id = '4175846' The Response is: Invalid query synt...
Parshant's avatar
Parshant
Boss
6 years ago

steffenschoene 

If you want parent of the message. Filtering by parent.id returns only direct replies or comments to the specified message. (This can be used to replicate a threaded view of messages.) Alternatively, see topic.

SELECT * FROM messages WHERE parent.id = '92'

filter by topic.id to return a list of all messages that have the specified topic as the root message in an unthreaded view. Alternatively, filter by parent.id to return only the direct replies/comments to a specified message.

SELECT * FROM messages WHERE topic.id = '255'