Hi!
I would do this in a filter to minimize network traffic to the server.
Filter 1:
Run If: empty
Set-Fields: The Form In Questions
Set-Fields-If: ('2' = $USER$ AND '3' < $TIMESTAMP$ - 3600)
tmp = $1$
Filter 2:
Run If: $LASTCOUNT$ > 123
Notify: xxx
The tmp-field is a dummy-field required to perform the query. If no target
field is specified, no query will be performed.
'2' = the user submitting the requests (Created By)
'3' = the time of request submission (Creation Date)
3600 is the number of seconds you want to control.
123 is the threshold.
xxx is the notification to someon.
You would probably want to put these numbers in some kind of
config-record, to allow change of the values.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hello All,
>
> I would appreciate your help with the following issue:
> I need to perform a certain query on each new request submission and
> notify
> a system administrator upon the query results. For instance, on each
> request
> submission, if the number of requests submitted by the same user within
> last
> hour exceeds a predefined threshold - I would like to send a notification.
>
> I've investigated active links, filters and escalations for that purpose
> but
> not sure what is the best way to handle this requirement, since it seems
> that I can't put a direct SQL statement in the "Run If" field.
> Need your advise...
>
> --
> View this message in context:
> http://www.nabble.com/Perform-a-query-in-active-link-or-filter-tp22402209p22402209.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
