Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053301Openbravo ERP01. General setuppublic2023-08-28 10:432023-08-28 11:54
Reporteraferraz 
Assigned Tojamie_reid 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053301: API Change: Create mandatory and unique C_Tax.value column
DescriptionAdded a new value column in C_Tax table defined as mandatory and unique.

The new C_Tax.value column is automatically filled with the values from C_Tax.name column.

The unique constraint is defined in the same way than the unique constraint for the C_Tax.name column.
Steps To Reproduce*
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0052639 closed jamie_reid It is required to add a unique identifier for each Tax Rate element in OB 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-08-28 10:43aferrazNew Issue
2023-08-28 10:43aferrazAssigned To => jamie_reid
2023-08-28 10:43aferrazModules => Core
2023-08-28 10:43aferrazTriggers an Emergency Pack => No
2023-08-28 10:43aferrazIssue generated from0052639
2023-08-28 10:50hgbotNote Added: 0154007
2023-08-28 10:53aferrazRelationship addedblocks 0052639
2023-08-28 10:54hgbotResolutionopen => fixed
2023-08-28 10:54hgbotStatusnew => closed
2023-08-28 10:54hgbotNote Added: 0154008
2023-08-28 10:54hgbotNote Added: 0154009
2023-08-28 11:54aferrazSummaryAPI Change: Create unique searchKey column in C_Tax => API Change: Create mandatory and unique C_Tax.value column
2023-08-28 11:54aferrazDescription Updatedbug_revision_view_page.php?rev_id=26709#r26709

Notes
(0154007)
hgbot   
2023-08-28 10:50   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/48 [^]
(0154008)
hgbot   
2023-08-28 10:54   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 36100c9fcec0603eb942cb3ebb911408f492dcb4
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 28-08-2023 10:49:12
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/36100c9fcec0603eb942cb3ebb911408f492dcb4 [^]

Fixes ISSUE-53301: Create unique searchKey column in C_Tax

---
M model/src-db/database/model/tables/C_TAX.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
M model/src-db/database/sourcedata/AD_FIELD.xml
---
(0154009)
hgbot   
2023-08-28 10:54   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/48 [^]