Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034910Retail ModulesStoreServerpublic2017-01-11 11:302017-02-15 15:05
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR17Q1.1Fixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034910: Errors when sorting and filtering symmetric ds windows in backoffice
DescriptionThe sorting on updated time and creation time in the Outgoing Symmetric DS batches window and Incoming Batches window does not work. Also check the implementation of the incoming error window

Filtering gives error in symmetric ds outgoing data events window (see screenshot).
Steps To ReproduceVisit the windows and sort and filter
Proposed SolutionSolve
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Selection_120.png (108,255) 2017-01-11 11:30
https://issues.openbravo.com/file_download.php?file_id=10280&type=bug
png

png Selection_121.png (159,094) 2017-01-11 11:31
https://issues.openbravo.com/file_download.php?file_id=10281&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2017-01-11 11:30mtaalNew Issue
2017-01-11 11:30mtaalAssigned To => mtaal
2017-01-11 11:30mtaalFile Added: Selection_120.png
2017-01-11 11:30mtaalOBNetwork customer => No
2017-01-11 11:30mtaalTriggers an Emergency Pack => No
2017-01-11 11:31mtaalFile Added: Selection_121.png
2017-01-14 15:56hgbotCheckin
2017-01-14 15:56hgbotNote Added: 0093561
2017-01-14 15:56hgbotStatusnew => resolved
2017-01-14 15:56hgbotResolutionopen => fixed
2017-01-14 15:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/f114d0fc41d2cb7ce59ebafebd496827bd7647c9 [^]
2017-01-14 15:57mtaalReview Assigned To => Sandrahuguet
2017-01-24 13:41SandrahuguetNote Added: 0093798
2017-01-24 13:41SandrahuguetStatusresolved => new
2017-01-24 13:41SandrahuguetResolutionfixed => open
2017-01-24 23:28hgbotCheckin
2017-01-24 23:28hgbotNote Added: 0093803
2017-01-24 23:28hgbotStatusnew => resolved
2017-01-24 23:28hgbotResolutionopen => fixed
2017-01-24 23:28hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/f114d0fc41d2cb7ce59ebafebd496827bd7647c9 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/a43c877a1cc1947936fb2e454cafb22d46080670 [^]
2017-01-25 10:04SandrahuguetNote Added: 0093813
2017-01-25 10:04SandrahuguetStatusresolved => new
2017-01-25 10:04SandrahuguetResolutionfixed => open
2017-01-29 21:43hgbotCheckin
2017-01-29 21:43hgbotNote Added: 0093906
2017-01-29 21:43hgbotStatusnew => resolved
2017-01-29 21:43hgbotResolutionopen => fixed
2017-01-29 21:43hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/a43c877a1cc1947936fb2e454cafb22d46080670 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/6d03ea7ce9a4c242ec24b19ba5a206ac681d2258 [^]
2017-02-14 13:49SandrahuguetNote Added: 0094314
2017-02-14 13:49SandrahuguetStatusresolved => new
2017-02-14 13:49SandrahuguetResolutionfixed => open
2017-02-15 10:25hgbotCheckin
2017-02-15 10:25hgbotNote Added: 0094349
2017-02-15 10:25hgbotStatusnew => resolved
2017-02-15 10:25hgbotResolutionopen => fixed
2017-02-15 10:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/6d03ea7ce9a4c242ec24b19ba5a206ac681d2258 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/9d3fc05316e2c7064f1732cd05eb0ac50141eee3 [^]
2017-02-15 15:05SandrahuguetNote Added: 0094364
2017-02-15 15:05SandrahuguetStatusresolved => closed

Notes
(0093561)
hgbot   
2017-01-14 15:56   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: f114d0fc41d2cb7ce59ebafebd496827bd7647c9
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sat Jan 14 15:56:28 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/f114d0fc41d2cb7ce59ebafebd496827bd7647c9 [^]

Fixes issue 34910: Errors when sorting and filtering symmetric ds windows in backoffice
Support alias in query and do correct order by clause

---
M src/org/openbravo/replication/symmetricds/datasource/OutgoingDataEventsDS.java
M src/org/openbravo/replication/symmetricds/datasource/SymmetricBaseDS.java
---
(0093798)
Sandrahuguet   
2017-01-24 13:41   
filter by source node id in Symmetric DS Outgoing Data Events window is not working
(0093803)
hgbot   
2017-01-24 23:28   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: a43c877a1cc1947936fb2e454cafb22d46080670
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Jan 24 23:28:05 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/a43c877a1cc1947936fb2e454cafb22d46080670 [^]

Fixes issue 34910: Errors when sorting and filtering symmetric ds windows in backoffice
Select the correct alias for specific columns

---
M src/org/openbravo/replication/symmetricds/datasource/OutgoingDataEventsDS.java
---
(0093813)
Sandrahuguet   
2017-01-25 10:04   
filter by any column in Symmetric DS Outgoing Data Events window is not working at all, only works if the value by which you filter is exactly the same (not working startswith and contains)
(0093906)
hgbot   
2017-01-29 21:43   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: 6d03ea7ce9a4c242ec24b19ba5a206ac681d2258
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sun Jan 29 21:43:40 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/6d03ea7ce9a4c242ec24b19ba5a206ac681d2258 [^]

Fixes issue 34910: Errors when sorting and filtering symmetric ds windows in backoffice
Support starts-with and case-insensitive search on string fields

---
M src/org/openbravo/replication/symmetricds/datasource/SymmetricBaseDS.java
---
(0094314)
Sandrahuguet   
2017-02-14 13:49   
contains filtering is not working

Steps to reproduce:
Filter by node in table name column
notice that no result are shown and should be shown some records like sym_node, sym_node_host
(0094349)
hgbot   
2017-02-15 10:25   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: 9d3fc05316e2c7064f1732cd05eb0ac50141eee3
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Feb 15 10:24:57 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/9d3fc05316e2c7064f1732cd05eb0ac50141eee3 [^]

Fixes issue 34910: Errors when sorting and filtering symmetric ds windows in backoffice
The datasource is a singleton, so members are shared between requests, this was incorrect.
Now using parameters instead of object members.

---
M src/org/openbravo/replication/symmetricds/datasource/SymmetricBaseDS.java
---
(0094364)
Sandrahuguet   
2017-02-15 15:05   
reviewed and tested