Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028481Openbravo ERPA. Platformpublic2014-12-23 19:252022-02-01 08:08
Reportercaristu 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket33230
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028481: Not possible to filter TableDir reference in grids of P&E window
DescriptionNot possible to filter TableDir reference in grids of P&E window
Steps To Reproduce1) Go to the [Tables and Windows] window and look for the C_RM_ReturnToVendorHQL table.

  a) In the HQL Query field replace the alias for iol.uOM with c_uom_id
  b) In the [Columns] tab, look for the uOM record and put the value c_uom_id for the db column name and name fields. Put its reference as TableDir
  This name changes are necessary as stated in the documentation[1]

2) Recompile and restart tomcat

3) Go to the [Return to vendor] window and click on the pick/edit lines button. Try to filter by the uom field. The following error appears in the log: ERROR org.openbravo.client.kernel.KernelUtils - could not resolve property: uom of: MaterialMgmtShipmentInOutLine



[1] http://wiki.openbravo.com/wiki/How_to_create_a_HQL_Based_Table#Column_Definition [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-12-23 19:25caristuNew Issue
2014-12-23 19:25caristuAssigned To => AugustoMauch
2014-12-23 19:25caristuOBNetwork customer => Yes
2014-12-23 19:25caristuModules => Core
2014-12-23 19:25caristuSupport ticket => 33230
2014-12-23 19:25caristuResolution time => 1425596400
2014-12-23 19:25caristuTriggers an Emergency Pack => No
2014-12-23 19:25caristuIssue Monitored: networkb
2015-02-09 10:17alostaleStatusnew => acknowledged
2015-02-23 13:30jonalegriaesarteTarget Version3.0PR15Q2 => 3.0PR15Q3
2015-02-26 09:12alostaleStatusacknowledged => scheduled
2015-02-26 09:12alostaleAssigned ToAugustoMauch => inigosanchez
2015-02-26 09:12alostalefix_in_branch => pi
2015-02-26 12:28inigosanchezNote Added: 0074959
2015-02-26 12:28inigosanchezNote Edited: 0074959bug_revision_view_page.php?bugnote_id=0074959#r7785
2015-02-26 12:29inigosanchezAssigned Toinigosanchez => alostale
2015-02-26 12:30inigosanchezIssue Monitored: inigosanchez
2015-02-27 08:00alostaleResolution time1425596400 =>
2015-02-27 08:00alostaleNote Added: 0075007
2015-02-27 08:00alostaleTypedefect => design defect
2015-02-27 08:00alostaleTarget Version3.0PR15Q3 =>
2015-02-27 08:00alostalefix_in_branchpi =>
2015-02-27 08:00alostaleStatusscheduled => acknowledged
2017-04-10 14:35alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0074959)
inigosanchez   
2015-02-26 12:28   
As we can see in the documentation[1], "...,the Table reference must be used,...". It is not possible to use TableDir reference.

[1] http://wiki.openbravo.com/wiki/How_to_create_a_HQL_Based_Table#Column_Definition [^]
(0075007)
alostale   
2015-02-27 08:00   
Moving to design defect: as explained in documentation, this was implemented in this manner per design, existing an easy workaround (usage of table references instead of tableDir).