You need to sign in to do that
Don't have an account?
MattyIce
Queue Email Alert
I'm interested in createing an email alert that informs me when the number of messages (a custom object) assined to a queue surpasses a set number. Normally, I set up email alerts with workflow rules as it is easy to add an email action but I think this case is a bit more coplicated then the rather simple workflow rules will permit. Any thoughts?
Alright, so you have a custom object Messages. These are assigned to a queue. What kind of queue is this? Is Queue a custom object as well?
The queues we are using are the default Salesforce ones. Here is SF's explaination of them:
I would do an "AFTER" APEX trigger on the custom object - and query all records that have that queue as the owner (along with whatever other criteria that you would need). If the count of records is above whatever threshold you specify - spin up and fire off a SingleEmailMessage to notify you (or others) of the situation.
-Andy
OK. I'll try this and report on how it works.