Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038489
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2018-05-03 18:032018-06-01 09:33
ReporterairaceburuView Statuspublic 
Assigned Tocaristu 
PrioritynormalResolutionfixedFixed in Version3.0PR18Q3
StatusclosedFix in branchFixed in SCM revision71b2155a083e
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038489: Wrong displayed value of a table reference inside a pick and execute when using hql query

DescriptionThe displayed value of a foreign key shown in a pick and execute is showing the table identifier instead of the one selected.

This happens when the pick and execute is populated from a hql query and the reference of the column is a table.
Steps To ReproduceThis is an example to get the above situation quickly with retail sampledata:

0) As System Administrator, go to [Reference window]. In "C_Region" Table reference, change the "Displayed Column" to Description instead of showing the name. Restart the application.
1) Go to Organization window, select Central Mountains Store and click on the button "Choose CC Warehouse".
2) Note that the value displayed in the P&E window for the region field is the name of the region instead of its description.
Proposed SolutionPatch attached
TagsNo tags attached.
Attached Filesdiff file icon proposedSolution.diff [^] (984 bytes) 2018-05-03 18:03 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00164653.0RC7 closedmtaal Combos on new ui doesn't show the record identifiers 
related to defect 00279123.0PR14Q4 closedAugustoMauch DateTime fields not properly formated to local time zone in grids of parameter windows 

-  Notes
(0104766)
caristu (developer)
2018-05-29 12:55
edited on: 2018-05-29 12:55

Repository: erp/devel/pi
Changeset: 71b2155a083e
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue, 29 May 2018 12:36:13 +0200
URL: https://code.openbravo.com/erp/devel/pi/rev/71b2155a083e [^]

fixes bug 38489: Display field of table reference can't be retrieved by some DS

Some datasources (like those extending ReadOnlyDataSourceService) use the DataToJsonConverter.convertToJsonObjects() method to return its result. When converting BaseOBObjects this method was not using the related Property to place its corresponding value into the resulting JSON.

Now we make use of the Property, this allows to retrieve the "Display Field" if the Property is a table reference, when invoking the DataToJsonConverter.addBaseOBObject() method.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataToJsonConverter.java
---

(0104768)
hgbot (developer)
2018-05-29 13:05

Repository: erp/devel/pi
Changeset: d9439b0b660be69fe52a0a352e8803c2c3214016
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue May 29 12:59:42 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d9439b0b660be69fe52a0a352e8803c2c3214016 [^]

related to bug 38489: Minor code improvements in convertToJsonObjects method

  - Use diamond operator
  - Iterate over the entrySet instead of the keySet
  - Removed useless comment

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataToJsonConverter.java
---
(0104791)
hudsonbot (developer)
2018-05-30 00:14

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/08f13cf1fa33 [^]
Maturity status: Test
(0104857)
alostale (manager)
2018-06-01 09:33

reviewed + tested

- Issue History
Date Modified Username Field Change
2018-05-03 18:03 airaceburu New Issue
2018-05-03 18:03 airaceburu Assigned To => platform
2018-05-03 18:03 airaceburu File Added: proposedSolution.diff
2018-05-03 18:03 airaceburu Modules => Core
2018-05-03 18:03 airaceburu Resolution time => 1526508000
2018-05-03 18:03 airaceburu Triggers an Emergency Pack => No
2018-05-29 10:23 caristu Relationship added related to 0016465
2018-05-29 10:29 caristu Relationship added related to 0027912
2018-05-29 12:34 caristu Steps to Reproduce Updated View Revisions
2018-05-29 12:43 caristu Assigned To platform => caristu
2018-05-29 12:55 caristu Note Added: 0104766
2018-05-29 12:55 caristu Note Edited: 0104766 View Revisions
2018-05-29 13:05 hgbot Checkin
2018-05-29 13:05 hgbot Note Added: 0104768
2018-05-29 13:06 caristu Status new => scheduled
2018-05-29 13:06 caristu Status scheduled => resolved
2018-05-29 13:06 caristu Fixed in SCM revision => 71b2155a083e
2018-05-29 13:06 caristu Resolution open => fixed
2018-05-29 13:07 caristu Review Assigned To => alostale
2018-05-29 13:07 caristu Fixed in SCM revision 71b2155a083e => https://code.openbravo.com/erp/devel/pi/rev/71b2155a083e [^]
2018-05-30 00:14 hudsonbot Checkin
2018-05-30 00:14 hudsonbot Note Added: 0104791
2018-06-01 09:33 alostale Note Added: 0104857
2018-06-01 09:33 alostale Status resolved => closed
2018-06-01 09:33 alostale Fixed in Version => 3.0PR18Q3


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker