0010787: Parameters for alerts

Description

It would be useful to be able to define parameters for alerts.

For instance, I want to be alerted when a certain invoiced amount is reached by a customer for a certain product. Nowadays I have to hard-code this amount, the business partner and the product in the alert itself. If my workmate wants the same alert for a different amount, business partner and product a new alert has to be setup.

Proposed Solution

A new tab called "Parameter", child of "Alert Rule" (General Setup || Application || Alert || Alert Rule)

One could define any variable name (unique name per alert) and value.

To make it more user friendly, there should be the possibility of somehow having a selector for the values. I mean, not having to copy paste the UUID value of a product or a business partner but having the product or business partner selector.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0020419) iciordia (viewer) 2009-09-28 22:11	Simple work-around in the meantime: if the alert needs a parameter (or a number of parameters) it is possible to add a 'info' table (implementing one row pattern) to hold those parameters and then define the alert sql using that table

(0020659) rafaroda (viewer) 2009-10-02 12:03	Can alerts take session variables? If so, another workaround would be to define a new session variable and use it.

Issue History
Date Modified	Username	Field	Change
2009-09-27 13:15	rafaroda	New Issue
2009-09-27 13:15	rafaroda	Assigned To	=> iciordia
2009-09-27 13:15	rafaroda	OBNetwork customer	=> No
2009-09-28 22:11	iciordia	Note Added: 0020419
2009-10-02 11:57	rafaroda	Description Updated
2009-10-02 12:03	rafaroda	Note Added: 0020659