Hello!<br><br>I&#39;m planning the development of the following functionality:<br><br><ul><li>Running xwiki instance on MySQL;</li><li>There will be an external database (a Datawarehouse to be more precise), with business indicators
</li><li>If any of the indicators reached a predefined limit value, I&#39; d like to have my xwiki generate a document with information about this event and send an e-mail alert to the administrator (or other users)</li></ul>
My strategy may be to create a IndicatorClass with some properties like name, description, businessarea, currentvalue, limitvalue, externalTable, externalColumn etc. Then I&#39;ll have to update these indicators on a regular basiis, which I could do with a procedure that will check the external database and get the latest values. For those which reached the limit values, I&#39;d like to generate automaticaly a document (of the class Risk for instance) and send an e-mail to warn of these risks.
<br><br>What do you think? Maybe a plugin could be a more structured way of doing this...<br>Thanks in advance for your tips :)<br><br>Bye,<br><br>Ricardo.<br>