Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041751Openbravo ERPA. Platformpublic2019-09-04 17:282019-09-20 13:01
Reporterucarrion 
Assigned Tocaristu 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q4 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041751: Problems to translate selector fields 'centrally maintained'
DescriptionTranslations for selector fields defined as 'centrally maintained' should be retrieved from the ad_element of their related ad_element.

Therefore, there exists triggers that detect changes done in the ad_element/ad_element_trl tables in order to properly update the labels of different application elements like parameters, selectors etc.

In the case of selector fields, this trigger is the OBUISEL_ELEMENT_TRL_TRG but it currently is not working properly.
Steps To Reproduce1) Go to the [Language] window
2) Select a language, for example Catalan (Spain). Set is as "System Language"
3) Click on "Verify Language" process to populate the _trl tables with the records to be translated to the selected language
4) Go to [Reference] window, select the "PLM Status" reference, navigate to "Defined Selector" > "Defined Selector Fields" subtab
5) Select a field, for example "Restrict Manufacture" and note that a new register exists under the "Selector Field Translation" tab
6) Edit the AD_Element related to the selector field. Following our example, go to the Element window, and look for the element with name "Restrict Manufacture"
7) Modify the translation of the element, for example by changing the name
8) Go back to the selector field and check its translation under "Selector Field Translation" tab. ERROR -> It has not changed. It should be updated with the same name set to the AD_Element
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-09-04 17:28ucarrionNew Issue
2019-09-04 17:28ucarrionAssigned To => platform
2019-09-04 17:28ucarrionOBNetwork customer => Gold
2019-09-04 17:28ucarrionModules => Core
2019-09-04 17:28ucarrionResolution time => 1569880800
2019-09-04 17:28ucarrionTriggers an Emergency Pack => No
2019-09-05 09:23caristuDescription Updatedbug_revision_view_page.php?rev_id=19353#r19353
2019-09-05 09:23caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=19355#r19355
2019-09-05 09:23caristuProposed Solution updated
2019-09-05 09:23caristuSeveritymajor => minor
2019-09-05 09:28caristuNote Added: 0114410
2019-09-17 17:22caristuDescription Updatedbug_revision_view_page.php?rev_id=19384#r19384
2019-09-17 17:22caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=19385#r19385
2019-09-17 17:22caristuProposed Solution updated
2019-09-17 17:22caristuNote Deleted: 0114410
2019-09-17 18:15hgbotCheckin
2019-09-17 18:15hgbotNote Added: 0114601
2019-09-17 18:15hgbotStatusnew => resolved
2019-09-17 18:15hgbotResolutionopen => fixed
2019-09-17 18:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/82dd9efb8ab3609d6948bbe4ce4ef79bb403e7e8 [^]
2019-09-17 18:16caristuReview Assigned To => alostale
2019-09-17 18:16caristuAssigned Toplatform => caristu
2019-09-18 15:36hudsonbotCheckin
2019-09-18 15:36hudsonbotNote Added: 0114643
2019-09-20 13:01alostaleNote Added: 0114692
2019-09-20 13:01alostaleStatusresolved => closed
2019-09-20 13:01alostaleFixed in Version => 3.0PR19Q4

Notes
(0114601)
hgbot   
2019-09-17 18:15   
Repository: erp/devel/pi
Changeset: 82dd9efb8ab3609d6948bbe4ce4ef79bb403e7e8
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Sep 17 18:03:45 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/82dd9efb8ab3609d6948bbe4ce4ef79bb403e7e8 [^]

fixes bug 41751: some selector field translations not being properly updated

  The translation of the selector fields marked as centrally maintained should be kept in sync with their corresponding AD_Element translations. The OBUISEL_ELEMENT_TRL_TRG is the trigger in charge of doing this job. But due to a wrong comparison in the implementation of this trigger, no selector field was being updated after modifying its corresponding element translation.

  Fixed this issue just by doing the proper comparison with AD_Language column.

---
M modules/org.openbravo.userinterface.selector/src-db/database/model/triggers/OBUISEL_ELEMENT_TRL_TRG.xml
---
(0114643)
hudsonbot   
2019-09-18 15:36   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/39a64f55bfbd [^]
Maturity status: Test
(0114692)
alostale   
2019-09-20 13:01   
reviewed + tested