Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038088Retail ModulesWeb POSpublic2018-03-09 09:352018-03-19 09:19
Reportermarvintm 
Assigned Torqueralta 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038088: API Change: A new check constraint needs to be added to obpos_userterminal_access
DescriptionCurrently it's possible to create more than one record in obpos_userterminal_access for the same combination of terminal and user. This must be prevented via a check constraint, but this is an API change. A related buildvalidation will be added to explain to customers that they need to fix their data first, before executing the update.
Steps To Reproduce.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0037794 closed rqueralta It is possible to create duplicate pos terminal access 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-03-09 09:35marvintmNew Issue
2018-03-09 09:35marvintmAssigned To => Retail
2018-03-09 09:35marvintmOBNetwork customer => No
2018-03-09 09:35marvintmTriggers an Emergency Pack => No
2018-03-09 09:35marvintmRelationship addedrelated to 0037794
2018-03-12 20:49rqueraltaAssigned ToRetail => rqueralta
2018-03-12 20:49rqueraltaStatusnew => scheduled
2018-03-12 20:56hgbotCheckin
2018-03-12 20:56hgbotNote Added: 0103170
2018-03-12 20:56hgbotStatusscheduled => resolved
2018-03-12 20:56hgbotResolutionopen => fixed
2018-03-12 20:56hgbotFixed in SCM revision => http://code.openbravo.com/retail/api-checks-retail/rev/af9b9ecf1d111a1dd694e61580575790a52d3a41 [^]
2018-03-19 09:19marvintmReview Assigned To => marvintm
2018-03-19 09:19marvintmStatusresolved => closed
2018-03-19 09:19marvintmFixed in Version => RR18Q2

Notes
(0103170)
hgbot   
2018-03-12 20:56   
Repository: retail/api-checks-retail
Changeset: af9b9ecf1d111a1dd694e61580575790a52d3a41
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Mon Mar 12 15:50:24 2018 -0400
URL: http://code.openbravo.com/retail/api-checks-retail/rev/af9b9ecf1d111a1dd694e61580575790a52d3a41 [^]

Fixed issue 38088: API Change: A new check constraint needs to be added to
obpos_userterminal_access

---
M model/modules/org.openbravo.retail.posterminal/src-db/database/model/tables/OBPOS_USERTERMINAL_ACCESS.xml
---