I've done a push field in a filter (that takes no action if no request matchesor any request matches) followed by an action that uses 'LASTCOUNT' * nn.
On Thu, 31 Mar 2011 13:55:34 +0000, "Martin, Dwayne - martinrd" <[email protected]> wrote: > Hi Rajesh, > > How about running an sql query, eg "select count(*) from whatevertable > where whateverconditions," then multiply that number by 20 or whatever. > > Dwayne Martin > James Madison University > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Nair, Rajesh SISPL > Sent: Thursday, March 31, 2011 9:23 AM > To: [email protected] > Subject: Email Notifcation > > ** > Dear List, > Am working on a older version 6.3 patch 24 on Oracle 9i > > Just got a requirement, so thought of listing out to the experts out here > > We have a HTML formatted mail which are being send to the end user. > Now the requirement is :- Say Service Desk assings the ticket to the Group > A and this Group A already have a list of ticket which are being worked > upon say 10 open tickets. > When a new ticket comes in to this group a mail should trigger to the user > saying the ticket will be attended to in so and so time. > The scenario is if one ticket takes approx say 20 minutes to work upon the > 11th ticket should send in a time say 11*20 i.e 220 minutes > > so the end user should get a mail saying your call will be attended in 220 > minutes.(20 minutes is not a realtime figure but taking 20 minutes a > becnhmark time for resolution) > > Any idea how can this be done > > With Best Regards > Rajesh > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
