How to Delete All Stream posts (it's all test data)

[crmclients]

I have several users testing today and need to at the end of the day delete all the Stream posts. Is there a way to do that w/o coding?
I think I saw it somewhere but can not find the thread.

100's of posts of garbage entries for testing

[item]

Hello crmclients,
i have not a response w/o coding .. but i have a idea with coding : let me explain.. i think this must be a feature request

stream -> is "note" entity with type "Post"
so i have make a code : when user post "@sms hello you" .. . a sms is go to the contact.
imagine we can develop this to : @deletePost ... so we delete post of contact
or @deleteTodayPost ...
we need to respect espocrm language... but a idea is there... like template

Regards

[eymen-elkum]

Just run this sql statement:

DELETE FROM `note` WHERE type='Post'

[crmclients]

Thanks for the input however we are using espocrm cloud ---> no coding, no SQL statements, no back end access

so it looks like it is not possible except to manually delete each one, yikes!

[esforim]

Yes, no way to for GUI Front End method.

I doubt even API work for stream. I said API because although it is not GUI but it is accessible for Cloud user.

[crmclients]

ok thanks for confirming - i ended up manually deleting the posts but for EspoCloud users in the same situation - you can put a ticket in and support can delete them for you