Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037794Retail ModulesWeb POSpublic2018-01-31 16:142018-03-23 10:46
Reporterjonibc 
Assigned Torqueralta 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037794: It is possible to create duplicate pos terminal access
DescriptionIt is possible to create duplicated entries in Window 'User' --> Tab 'POS Terminal access'.

Steps To ReproduceLog into backend:

1- Open 'User' window, select a user record, go to Tab 'POS Terminal Access'
2- Create a record for any POS Terminal.
3- Create another record for the same POS Terminal.
4- Check that no error is raised.
Proposed SolutionAdd a constraint to avoid add duplicated entries in this table.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038088 closed rqueralta API Change: A new check constraint needs to be added to obpos_userterminal_access 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-31 16:14jonibcNew Issue
2018-01-31 16:14jonibcAssigned To => Retail
2018-01-31 16:14jonibcOBNetwork customer => No
2018-01-31 16:14jonibcTriggers an Emergency Pack => No
2018-01-31 16:24marvintmOBNetwork customerNo => Yes
2018-01-31 16:24marvintmResolution time => 1519167600
2018-01-31 16:25jonibcIssue Monitored: jonibc
2018-01-31 22:53rqueraltaAssigned ToRetail => rqueralta
2018-01-31 22:53rqueraltaStatusnew => scheduled
2018-03-08 18:34marvintmResolution time1519167600 => 1521068400
2018-03-09 09:35marvintmRelationship addedrelated to 0038088
2018-03-12 20:56hgbotCheckin
2018-03-12 20:56hgbotNote Added: 0103171
2018-03-12 20:56hgbotStatusscheduled => resolved
2018-03-12 20:56hgbotResolutionopen => fixed
2018-03-12 20:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2c321d7b4f442702a8e29bd2b596cbd903cde8f [^]
2018-03-19 09:16marvintmNote Added: 0103338
2018-03-19 09:16marvintmStatusresolved => new
2018-03-19 09:16marvintmResolutionfixed => open
2018-03-19 16:18hgbotCheckin
2018-03-19 16:18hgbotNote Added: 0103349
2018-03-19 17:46rqueraltaStatusnew => scheduled
2018-03-19 17:46rqueraltaStatusscheduled => resolved
2018-03-19 17:46rqueraltaResolutionopen => fixed
2018-03-23 10:46marvintmReview Assigned To => marvintm
2018-03-23 10:46marvintmStatusresolved => closed
2018-03-23 10:46marvintmFixed in Version => RR18Q2

Notes
(0103171)
hgbot   
2018-03-12 20:56   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a2c321d7b4f442702a8e29bd2b596cbd903cde8f
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Fri Mar 09 16:03:03 2018 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2c321d7b4f442702a8e29bd2b596cbd903cde8f [^]

Fixed issue 37794: It is possible to create duplicate pos terminal access

---
M src-db/database/model/tables/OBPOS_USERTERMINAL_ACCESS.xml
A build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.class
A build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794Data.class
A src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.java
A src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794_Data.xsql
A src-util/modulescript/src/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794Data.java
---
(0103338)
marvintm   
2018-03-19 09:16   
Modulescript logic is correct, but the version that should be checked should be 3500, not 3300. Otherwise, the modulescript will not be executed in 18Q1, and the constraint will therefore fail if data is not correct.
(0103349)
hgbot   
2018-03-19 16:18   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: e879bc101b60dd1e0a43a8c7beaf7c100ca02fdf
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Mon Mar 19 11:03:06 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e879bc101b60dd1e0a43a8c7beaf7c100ca02fdf [^]

Related to issue 37794: It is possible to create duplicate pos terminal access

---
M build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue37794.java
---