Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0028481Openbravo ERPA. Platformpublic2014-12-23 19:252022-02-01 08:08
caristu 
Triage Platform Base 
normalminoralways
acknowledgedopen 
5
 
 
Core
No
0028481: Not possible to filter TableDir reference in grids of P&E window
Not possible to filter TableDir reference in grids of P&E window
1) 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 [^]
No tags attached.
Issue History
2014-12-23 19:25caristuNew Issue
2014-12-23 19:25caristuAssigned To => AugustoMauch
2014-12-23 19:25caristuModules => Core
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).