Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0034060 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
feature request | [Retail Modules] StoreServer | minor | have not tried | 2016-09-22 16:55 | 2016-09-27 11:11 | |||
Reporter | AugustoMauch | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | RR16Q4 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 73886d6aac8a | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | mtaal | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0034060: Provide a way to support columns that are exclude from synchronization only if some conditions apply | |||||||
Description | Right now, when a column is excluded from synchronization from the Synchronized Table window, that column will be excluded regardless of the direction of the synchronization (central to store or store to central) and regardless of whether the change being synchronized is an insert or an update. It would be useful to define the direction where the column should be excluded (i.e. exclude from store to central but not otherwise) and to define that a column should be excluded only from inserts/updates. | |||||||
Steps To Reproduce | - | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0090182) hgbot (developer) 2016-09-23 08:42 |
Repository: erp/pmods/org.openbravo.replication.symmetricds Changeset: 73886d6aac8ae3700e10996b93822b0cc82706ee Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Fri Sep 23 08:29:29 2016 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/73886d6aac8ae3700e10996b93822b0cc82706ee [^] Fixes issue 34060: Provides a way to define columns to be excluded partially Three new configurations have been added to the STRSYNC_EXCLUDEDCOL table: - Exclusion direction. To specify whether the column should be excluded in the synchs from Central to Store, from Store to Central or in both directions. This configuration is only available is the table is synchronized bidirectionally. - Exclude on update. To specify whether the column should be excluded from updates. This configuration is only available is updates are synched on the synchronized table - Exclude on insert. To specify whether the column should be excluded from insertions. This configuration is only available is insertions are synched on the synchronized table A WriterFilterAdapter has been implemented to handle these partially excluded columns. It only takes effect if the table being modified has partially excluded column. The exclusion is done by modifying to structures that SymmetricDS uses to know what are the values that should be synched. If a column is excluded from an insertion the default value will be used, if any, and if it is excluded from an update the previous value will remain. --- M src-db/database/model/tables/STRSYNC_EXCLUDEDCOL.xml M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src/org/openbravo/replication/symmetricds/SymmetricDSConfiguration_data.xsql M src/org/openbravo/replication/symmetricds/SynchronizationTableValidation.java A src/org/openbravo/replication/symmetricds/extensions/PartialExclusionWriterFilterAdapter.java --- |
(0090239) mtaal (manager) 2016-09-26 09:25 |
Reviewed and tested |
(0090290) hgbot (developer) 2016-09-27 11:11 |
Repository: erp/pmods/org.openbravo.replication.symmetricds Changeset: dd47094ba772280f3b4b9f34dec733c2976b57f6 Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Tue Sep 27 11:08:19 2016 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/dd47094ba772280f3b4b9f34dec733c2976b57f6 [^] Related with issue 34060: ExcludeOnInsert column should be mandatory --- M src-db/database/model/tables/STRSYNC_EXCLUDEDCOL.xml --- |
Issue History | |||
Date Modified | Username | Field | Change |
2016-09-22 16:55 | AugustoMauch | New Issue | |
2016-09-22 16:55 | AugustoMauch | Assigned To | => AugustoMauch |
2016-09-22 16:55 | AugustoMauch | Triggers an Emergency Pack | => No |
2016-09-22 17:06 | AugustoMauch | Status | new => scheduled |
2016-09-22 18:28 | AugustoMauch | Review Assigned To | => mtaal |
2016-09-23 08:42 | hgbot | Checkin | |
2016-09-23 08:42 | hgbot | Note Added: 0090182 | |
2016-09-23 08:42 | hgbot | Status | scheduled => resolved |
2016-09-23 08:42 | hgbot | Resolution | open => fixed |
2016-09-23 08:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/73886d6aac8ae3700e10996b93822b0cc82706ee [^] |
2016-09-26 09:25 | mtaal | Note Added: 0090239 | |
2016-09-26 09:25 | mtaal | Status | resolved => closed |
2016-09-26 09:25 | mtaal | Fixed in Version | => RR16Q4 |
2016-09-27 11:11 | hgbot | Checkin | |
2016-09-27 11:11 | hgbot | Note Added: 0090290 | |
2016-10-18 11:51 | AugustoMauch | Relationship added | has duplicate 0033936 |
Copyright © 2000 - 2009 MantisBT Group |