Project and Portfolio Management Practitioners Forum
cancel

Notifications Details

Highlighted
avinash_k
Contributor.

Notifications Details

HI,

 

I am looking for the notifications detail stored in the database but not able to find out which table to be queried. I am moving from 1 step to other step while clicking on some action button. Based on the action button, email notification to be sent to users. I am trying to search where i can get the details of this transition including notification details.

 

 

2 REPLIES
Amanjyot
Respected Contributor.

Re: Notifications Details

Try  knta_notif_txn_details,knta_notif_txn_parents, knta_notif_txn_recipients

 

Regards,

Aman

abhishekkumar
Frequent Contributor.

Re: Notifications Details

The notification details can be found on the following DB tables

 

1. KNTA_NOTIF_TXN_PARENTS (contains the details about the entity from which the notification is sent along with the details such as Subject and Email Body)

2. KNTA_NOTIF_TXN_DETAILS (Intermediary table which connects the KNTA_NOTIF_TXN_PARENTS and KNTA_NOTIF_TXN_RECIPIENTS table)

NOTE: When you connect to the KNTA_NOTIF_TXN_RECIPIENTS table, pick the row with the positive detail ID on the same.

3. KNTA_NOTIF_TXN_RECIPIENTS (contains details about the recipients marked with whether they are marked in TO or CC)

 

Transitions can be located under the following DB tables

 

1. KWFL_STEP_TRANSACTIONS

2. KWFL_STEP_TRANSACTION_HISTORY

 

Cheers,

Abhishek