Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting Notifications

SOLVED
Go to solution
Highlighted
Luis Puente
Regular Collector

Deleting Notifications

Hello,

I've created some notifications inside a PPM workflow and done some test before configuring my SMTP connection. I want to configure it now, but I need to delete all my test notifications generated before doing it, my "outbox". Which tables do I have to truncate? There are several tables notification related with:



KNTA_NOTIF_INTERVALS_LOC

KNTA_NOTIF_INTERVALS_NLS

KNTA_NOTIF_TXN_COLUMNS

KNTA_NOTIF_TXN_DETAILS

KNTA_NOTIF_TXN_PARENTS

KNTA_NOTIF_TXN_RECIPIENTS

KNTA_NOTIF_TYPE_MESSAGES

KNTA_NOTIFICATION_COLUMNS

KNTA_NOTIFICATION_RECIPIENTS

KNTA_NOTIFICATION_TYPES

KNTA_NOTIFICATIONS_LOC

KNTA_NOTIFICATIONS_NLS

KNTA_NOTIFICATIONS_TEMP



Thanks
4 REPLIES
victoria loft
Collector
Solution

Re: Deleting Notifications

knta_notif_txn_parents
Luis Puente
Regular Collector

Re: Deleting Notifications

thanks, i will only truncate this table
Luis Puente
Regular Collector

Re: Deleting Notifications

Ok thanks

Its corrects !!!
Cesar Roque
Regular Collector

Re: Deleting Notifications

The easiest way is set Y to the NOTIFICATION_SENT_FLAG at KNTA_NOTIF_TXN_PARENTS table.

Regards
//Add this to "OnDomLoad" event