View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000777SymmetricDSNew Featurepublic2012-08-16 20:262022-05-24 14:52
Reporterelong Assigned To 
Prioritynormal 
Status newResolutionopen 
Summary0000777: Dependency on child table for syncing additional data
DescriptionUse Case 1: A transfer document with line items is entered at store 3 with a "transfer to" field of store 1. At CO, the status on the document header is changed to Approved. The document and line items need sent to store 1. The store and status information is only on the document header, not the line items. Then the "transfer to" store field is changed to store 2. Now, we need to delete the document and lines from store 1 and sync it to store 2.

Use Case 2: Each store is assigned a catalog from which supplies are ordered. The store_catalog table links store 1 to catalog A. The catalog table is synced to store 1 with only the items belonging to catalog A. At central office, store 1 is re-assigned to catalog B. Now store 1 needs to be synced so it has catalog A items and not catalog B items.

Use Case 3: A child record has the necessary data to determine how a parent record is routed. When the parent record is created without a child, there is not enough information to route the parent. When the child record is created, the parent record should be routed based on the data in the child record.

Solution:
When syncing the parent table, SymmetricDS should check child tables to see if rows should be synced from there also. Comparing old data to new data, it can be seen that the old data is a relationship to rows that need deleted.
Tagsdata sync

Relationships

related to 0001570 closedchenson SymmetricDS Add custom_before_insert/update/delete_text to trigger for help with routing dependent rows 
related to 0005295 closedemiller SymmetricDS Pro Relational to JSON writer with nesting using group of tables 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-08-16 20:26 elong New Issue
2012-08-16 20:29 elong Project SymmetricDS Pro => SymmetricDS
2012-09-16 15:51 chenson Target Version => 3.3.0.pre.1
2013-01-30 01:56 chenson Target Version 3.3.0.pre.1 => 3.4.0
2013-02-14 13:59 abrougher Description Updated View Revisions
2013-03-18 00:56 chenson Target Version 3.4.0 =>
2014-02-13 15:33 elong Relationship added related to 0001570
2019-04-12 17:39 admin Tag Attached: data sync
2022-05-24 14:52 elong Relationship added related to 0005295