wf_notifications mail_status mail
Notification mailer is uses to send Email Notifications to the User. We see the Workflow Notifications in the Table wf_notification. If you want to check whether the Workflow Notification Mailer , has sent the Email notification or not , then you can take the help of this Table wf_notification. Column Mail_Status in the wf_notification shows the Email status of the Notification. if Mail_Status showing 'mail' Then it means , Workflow Notification mailer has not picked this record to send Email. This record is Pending to Process by Workflow Mailer to send Email to the Users. Once the Workflow Mailer picked the Record to Send Email and it process successfully then the column mail_status will be changed to 'Sent'.
This is the SQL Query to find the Pending Records of the Workflow Notification Mailer which is yet pending to sent emails.
Select * from Wf_Notifcations
Where Mail_Status='MAIL'.
This is the SQL Query to find the Pending Records of the Workflow Notification Mailer which is yet pending to sent emails.
Select * from Wf_Notifcations
Where Mail_Status='MAIL'.
This is the SQL Query to find the Processed records of the Workflow notification to which the email notification has been sent.
Select * from Wf_Notifcations
Where Mail_Status='SENT'
3 comments:
Your website have a valuable information,thanks for sharing information.
Oracle Fusion Financials Training in Ameerpet
Thank you for providing and sharing good information to the students it will be very helpful to them for Choosing best course in future. Oracle R12 Financials Training in Hyderabad
The education is necessary because through this you become an expert and get acknowledge about different important aspects. Also, focus on the IT field, PSE-Strata Questions Answers is the most nonpareil platform which assures you 100% guarantee about we have provided demo questions to probe the quality we are offering you success in any IT certification. Just visit us and get the utmost facilities.
Post a Comment