Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023268Openbravo ERPA. Platformpublic2013-03-08 12:272013-03-14 18:49
Reporteregoitz 
Assigned Toshankarb 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP22Fixed in Version3.0MP22 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023268: The ad_column_identifier does not work for a table wich identifiers are new selectors
DescriptionThe ad_column_identifier does not work for a table wich identifiers are new selectors.
Steps To Reproduce-Add a new table pr_series with the mandatory fields and name
-Define it on the application dictionarly and check the name as identifier
-Define a new selector for that table created
-Create a new column on m_product table. Name em_pr_series1
-Define the column on the application dictionary
-Check it as identifier and assign to it the new selector.
-Compile and restart tomcat
-Fill a row on the pr_series
-ON a product select on the new selector of the new column the element created
-Use the column identifier for that register
See that the value shown for em_pr_series1 is the id when it should be the name fo the element selected on the selector.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00232673.0MP22 closed shankarb Error with ComboTableData when refering to columns defined as new selector for table containing also identifiers as new selector 
Attached Files? com.sample-1.0.0.obx (14,386) 2013-03-14 09:33
https://issues.openbravo.com/file_download.php?file_id=6026&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-03-08 12:27egoitzNew Issue
2013-03-08 12:27egoitzAssigned To => AugustoMauch
2013-03-08 12:27egoitzModules => Core
2013-03-08 12:27egoitzTriggers an Emergency Pack => No
2013-03-08 12:33egoitzRelationship addedrelated to 0023267
2013-03-08 12:33egoitzIssue Monitored: networkb
2013-03-08 12:36AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4488#r4488
2013-03-11 09:48AugustoMauchAssigned ToAugustoMauch => shankarb
2013-03-14 06:59shankarbStatusnew => scheduled
2013-03-14 06:59shankarbfix_in_branch => pi
2013-03-14 07:12shankarbReview Assigned To => AugustoMauch
2013-03-14 07:12shankarbfix_in_branchpi =>
2013-03-14 07:12shankarbIssue Monitored: AugustoMauch
2013-03-14 07:13hgbotCheckin
2013-03-14 07:13hgbotNote Added: 0057239
2013-03-14 09:33shankarbFile Added: com.sample-1.0.0.obx
2013-03-14 09:34shankarbNote Added: 0057240
2013-03-14 10:02shankarbStatusscheduled => resolved
2013-03-14 10:02shankarbFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/e4bb3b8195b4 [^]
2013-03-14 10:02shankarbResolutionopen => fixed
2013-03-14 10:03shankarbNote Added: 0057242
2013-03-14 18:49AugustoMauchNote Added: 0057265
2013-03-14 18:49AugustoMauchStatusresolved => closed
2013-03-14 18:49AugustoMauchFixed in Version => 3.0MP22

Notes
(0057239)
hgbot   
2013-03-14 07:13   
Repository: erp/devel/pi
Changeset: e4bb3b8195b471b305f17b8117af871860641d1a
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu Mar 14 11:42:06 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e4bb3b8195b471b305f17b8117af871860641d1a [^]

Related to Issue 23268 : ad_column_identifier does not work with UI selector

Handled UI Selectors in ad_column_identifier_ref_sql method.
Before this the id of the table was returned instead of the identifier.

---
M src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml
---
(0057240)
shankarb   
2013-03-14 09:34   
Attached the module used for testing.
(0057242)
shankarb   
2013-03-14 10:03   
The Issue has been fixed with the changeset e4bb3b8195b4
(0057265)
AugustoMauch   
2013-03-14 18:49   
Code reviewed and verified in pi@6f316468c5e7