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 syntax

Is there an other way to get all replies of a conversation/thread?

Greetings

  • 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'