If you can't find a discussion entry in Beta or Test because it was too recent, it will be stored in Canvas Data. It may be a day or two before that particular entry will be available in Canvas Data, but it will appear. If your school has access to Canvas Data, the data can be extracted from discussion_entry_dim, discussion_entry_fact, discussion_topic_dim, and discussion_topic_fact table files into excel or a temporary database.
The item you are looking for will first appear as 'active' and in the next days batch of files appear as 'deleted'. No matter which you see it as, you can restore the reply one by copying the "message" field text from the database or excel sheets and re-post it.
Here is the sql query I used in my temp database to find the entries for a specific course, filling in the xxxxx with the canvas_id of the course from the course URL.
select ed.*
from discussion_entry_dim ed
join discussion_entry_fact ef on ef.discussion_entry_id=ed.id
join discussion_topic_fact tf on tf.discussion_topic_id=ef.topic_id
join discussion_topic_dim td on td.id=tf.discussion_topic_id
where td.course_id in (select id from course_dim where canvas_id=xxxxx)
-- td.canvas_id = xxxxxxxxxx
-- tf.user_id in (select id from user_dim where canvas_id = xxxxxxx)
order by ed.created_at desc
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.