Delete, and query from conversations table
Table Specific Information
To query the Conversations table, TicketId should be mentioned in the WHERE clause. For example:
SELECT * FROM Conversations WHERE TicketId = 100
Note: The Conversations table can only be filtered on TicketId.
Following is an example of how to delete from the Conversations table:
DELETE FROM Conversations WHERE Id = 786
ID of the conversation.
Content of the conversation in HTML.
Content of the conversation.
Email address the message was sent from.
True if a particular conversation should appear as being created from outside (i.e., not through web portal)
True if the note is private
Email address from which replies are sent.
Denotes the type of conversation.
Ticket id to which conversation is added.
Email addresses of agents/users who need to be notified about this conversation
ID of the agent who added conversation.
Conversation creation timestamp.
Conversation updated timestamp.