Accessing / Modifying the comment threadid on the new comment thread

App Building
1

Hi,

I am using the new comment thread for a few months now,
for threadId i am using an internal id from my database

i had to refactor my app and move it to another database and as a result , the ids which used for the comment thead - changed.

Is there a way to edit the already entered data and thread id , or at least access it ?
Because now my comment threads are displayed on wrong rows

Thanks

2

hello @idan_cohen

After the recent database migration, we're encountering an issue with our comment threads. The threadId values in our comments table no longer match the new database IDs, causing comments to display incorrectly.

The most efficient solution is to directly update the threadId in the database using a SQL UPDATE query with a mapping of old to new IDs

UPDATE comments
SET thread_id = new_ids.new_id
FROM (
    SELECT old_id, new_id
    FROM id_mapping_table -- Replace with the actual name of your mapping table
) AS new_ids
WHERE comments.thread_id = new_ids.old_id;

here is the SQL update Query