Hi everyone,

I'm new to TOS and struggling with inserting some manual SQL code. Essentially, I have a source SQL table containing messages between users and a target SQL table threads. Each message has a thread_id which connects the message to the corresponding thread.

The thread table has an attribute num_messages which indicates the number of message that the thread contains. I created a t_Map that connects both tables. Where and how can I insert the SQL statement that calculates the number of messages and inserts the value in the num_messages attribute of the thread table?

I thought about the expression editor, however, it seems to be the case that I can only enter Java statements.

Thanks for your help,
Stephan