Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021655Openbravo ERPA. Platformpublic2012-09-14 12:582012-09-26 17:19
Reporteregoitz 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP14 
Target VersionFixed in Version3.0MP16 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021655: The alert to check disabled triggers does not work
DescriptionThe problem is that the alerts checks the information on user_triggers view what is not correct.
this view retunrs as the triggers as enabled because the status is hardcoded with enabled directly.

Steps To Reproduce-Disable a trigger
-Execute the alert that check disable triggers.
-Not rows are returned
Proposed Solutionon the user tables replace

'ENABLED'::text AS status

with

(case when tgenabled='D' then 'DISABLED'::text ELSE 'ENABLED'::text END) AS status
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-14 12:58egoitzNew Issue
2012-09-14 12:58egoitzAssigned To => migueldejuana
2012-09-14 12:58egoitzModules => Core
2012-09-14 12:58egoitzOBNetwork customer => Yes
2012-09-14 13:18egoitzAssigned Tomigueldejuana => dmiguelez
2012-09-14 14:57dmiguelezAssigned Todmiguelez => jonalegriaesarte
2012-09-17 08:48egoitzSummaryThe alert to check disabled alerts does not work => The alert to check disabled triggers does not work
2012-09-18 13:03jecharriAssigned Tojonalegriaesarte => jecharri
2012-09-18 15:24hgbotCheckin
2012-09-18 15:24hgbotNote Added: 0052204
2012-09-18 15:24hgbotStatusnew => resolved
2012-09-18 15:24hgbotResolutionopen => fixed
2012-09-18 15:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/861d5861059e10910ef7a68b914afd5111a61ea1 [^]
2012-09-18 15:39jecharriNote Added: 0052205
2012-09-18 16:39egoitzClosed by => egoitz
2012-09-18 16:39egoitzNote Added: 0052208
2012-09-18 16:39egoitzStatusresolved => closed
2012-09-18 16:39egoitzFixed in Version => 3.0MP16
2012-09-26 17:19hudsonbotCheckin
2012-09-26 17:19hudsonbotNote Added: 0052779

Notes
(0052204)
hgbot   
2012-09-18 15:24   
Repository: erp/devel/pi
Changeset: 861d5861059e10910ef7a68b914afd5111a61ea1
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Sep 18 15:22:53 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/861d5861059e10910ef7a68b914afd5111a61ea1 [^]

Fixes issue 21655: The alert to check disabled triggers does not work

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0052205)
jecharri   
2012-09-18 15:39   
Test plan:
-Disable a trigger
-Execute the alert that check disable triggers.
-One alert per trigger is created.

Verify that if you execute queries in table user_trigger, you are able to see disabled and enabled triggers.
(0052208)
egoitz   
2012-09-18 16:39   
verified with the testing plan provided
(0052779)
hudsonbot   
2012-09-26 17:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test