Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034358Retail ModulesStoreServerpublic2016-10-31 20:162017-02-14 16:01
Reportermtaal 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR17Q2Fixed in VersionRR17Q2 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034358: Add trigger to several strsync tables to prevent changing the records if the module is not in development
DescriptionThere are several strsync tables [1] which have an ad_module_id field. Normally for these AD tables there should also be a trigger to prevent changing the table if the module is not in development (like [2]). This should also be done for the strsync tables with an ad_module_id.

[1]
strsync_custom_router
strsync_excludedcol
strsync_sync_params
strsync_synch_channel
strsync_synchronizedtable

[2]
https://code.openbravo.com/erp/devel/pi/file/b06a2c5097c1/src-db/database/model/triggers/AD_FIELD_MOD_TRG.xml [^]
Steps To ReproduceSee description
Proposed SolutionAdd MOD trigger
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-10-31 20:16mtaalNew Issue
2016-10-31 20:16mtaalAssigned To => AugustoMauch
2016-10-31 20:16mtaalTriggers an Emergency Pack => No
2016-12-29 11:42AugustoMauchTarget VersionRR17Q1 => RR17Q2
2017-02-09 18:02hgbotCheckin
2017-02-09 18:02hgbotNote Added: 0094188
2017-02-09 18:02hgbotStatusnew => resolved
2017-02-09 18:02hgbotResolutionopen => fixed
2017-02-09 18:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/ef49764101f8e8634e761657f32014a7ae884822 [^]
2017-02-09 18:03AugustoMauchReview Assigned To => mtaal
2017-02-14 16:01mtaalNote Added: 0094322
2017-02-14 16:01mtaalStatusresolved => closed
2017-02-14 16:01mtaalFixed in Version => RR17Q2

Notes
(0094188)
hgbot   
2017-02-09 18:02   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: ef49764101f8e8634e761657f32014a7ae884822
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Feb 09 18:00:07 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/ef49764101f8e8634e761657f32014a7ae884822 [^]

Fixes issue 34358: Adds check-in-development triggers to tables of this module

---
A src-db/database/model/triggers/STRSYNC_CHANNEL_TRG.xml
A src-db/database/model/triggers/STRSYNC_EXCL_COL_MOD_TRG.xml
A src-db/database/model/triggers/STRSYNC_ROUTER_MOD_TRG.xml
A src-db/database/model/triggers/STRSYNC_SYNC_PARAM_MOD_TRG.xml
A src-db/database/model/triggers/STRSYNC_SYNC_TABLE_TRG.xml
---
(0094322)
mtaal   
2017-02-14 16:01   
Reviewed and tested