Project:
| View Revisions: Issue #13732 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0013732: The field where clause on the alert definition window does not work well if you want to refere to ad_user_id field | ||
| Revision | 2010-06-22 17:21 by egoitz | ||
| Steps To Reproduce | -Create an alert as following: select req.m_requisition_id as referencekey_id, req.documentno as record_id, 0 as ad_role_id, req.ad_user_id as ad_user_id, 'La solicitud '||req.documentno||' no tiene descripcion' as description, 'Y' as isActive, req.ad_org_id, req.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedby from m_requisition req where req.description is null; tab= Header - Requisition whereclause, = ad_user_id=@#ad_user_id@ -Go to requisition window and create a new requisition without description. -After receive the alert you won't be able to access to the alert form If you change the whereclause to a.ad_user_id=@#ad_user_id@ you can go to the form but the counter is not updated. If you chage to ad_alert.ad_user_id=@#ad_user_id@ you can not go to the form but the counter is updated. |
||
| Revision | 2010-06-22 17:20 by egoitz | ||
| Steps To Reproduce | -Create an alert as following: select req.m_requisition_id as referencekey_id, req.documentno as record_id, 0 as ad_role_id, req.ad_user_id as ad_user_id, 'La solicitud '||req.documentno||' no tiene descripcion' as description, 'Y' as isActive, req.ad_org_id, req.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedby from m_requisition req where req.description is null; tab= Header - Requisition whereclause, = ad_user_id=@#ad_user_id@ -Go to requisition window and create a new requisition without description. -After receive the alert you won't be able to access to the alert form If you change the whereclause to a.ad_user_id=@#ad_user_id@ you can go to the form but the counter is not updated. If you chage to ad_alert.ad_user_id=@#ad_user_id@ you can not go to the form but the counter is updated. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |