You are not logged in.
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,