Home › Forums › Luminis Platform / System

deleting all targeted announcements

Fri, 2008-05-09 16:22 — wjdennen

Hi,

Has anyone found a good way of deleting lots of targeted announcement en mass? I can delete 5 at a time via the GUI, but this is not ideal, since we'd like to delete > 1000 TAs.

I see 4 tables in the Luminis db. All have names which begin with TA_.

If we're going to delete all the TAs, can we just clear out these tables?

Are there any other ways of deleting lots of TAs (in case we don't want to delete all of them)?

Thanks.

0
No votes yet
‹ Luminis Mashup? Portal Logo Padding ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Fri, 2008-05-09 16:38 — bwalker

Set the expire date

I'm not sure how the Announcement sweeper works, but there must be one that deletes expired messages.
So, why not set the expirationdate in ta_message to be yesterday for the ones you want to delete and see what happens. Let the system clear out the data for you.

The only issue is that funny number they use for dates.
See http://www.lumdev.net/node/557 for help on that one.

bob.