Openbravo Issue Tracking System - Openbravo ERP
I created a new alert rule and added the following sql:
select trigger_name as referencekey_id,
null as record_id,
'2701' as ad_role_id,
'92161F56AA0F0877E040290A548868A7' as ad_user_id,
'Constraint '||trigger_name||' on table '||table_name||' is not enabled' as description,
'Y' as isActive,
0 as ad_org_id,
'1969' as ad_client_id,
now() as created,
0 as createdBy,
now() as updated,
0 as updatedBy
from user_triggers
where status!='ENABLED'
I added an alert recipient, selected a role and uwser, made it active and check send email.
On the user, I made sure the email address is correct. On the client I set up the mail host, request email, request user and request user password. The mail host is an smtp server working on port 25 and the email accounts are all authorized mail accounts on the server.
The alert rule sql returns the following:
OPENBRAVO@ipvdev10> select trigger_name as referencekey_id,
2 null as record_id,
3 '2701' as ad_role_id,
4 '92161F56AA0F0877E040290A548868A7' as ad_user_id,
5 'Constraint '||trigger_name||' on table '||table_name||' is not enabled' as description,
6 'Y' as isActive,
7 0 as ad_org_id,
8 '1969' as ad_client_id,
9 now() as created,
10 0 as createdBy,
11 now() as updated,
12 0 as updatedBy
13 from user_triggers
14 where status!='ENABLED'
15 /
REFERENCEKEY_ID R AD_R AD_USER_ID DESCRIPTION
------------------------------ - ---- -------------------------------- ----------------------------------------------------------------------------------
AD_ACCOUNTINGRPT_ELEMENT_TRG 2701 92161F56AA0F0877E040290A548868A7 Constraint AD_ACCOUNTINGRPT_ELEMENT_TRG on table
1 row selected.
saicalertissue.docx (579,722) 2011-01-11 18:31https://issues.openbravo.com/file_download.php?file_id=3470&type=bug