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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028481
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformminoralways2014-12-23 19:252022-02-01 08:08
ReportercaristuView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028481: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0074959)
inigosanchez (developer)
2015-02-26 12:28
edited on: 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 (manager)
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).

- Issue History
Date Modified Username Field Change
2014-12-23 19:25 caristu New Issue
2014-12-23 19:25 caristu Assigned To => AugustoMauch
2014-12-23 19:25 caristu Modules => Core
2014-12-23 19:25 caristu Resolution time => 1425596400
2014-12-23 19:25 caristu Triggers an Emergency Pack => No
2014-12-23 19:25 caristu Issue Monitored: networkb
2015-02-09 10:17 alostale Status new => acknowledged
2015-02-23 13:30 jonalegriaesarte Target Version 3.0PR15Q2 => 3.0PR15Q3
2015-02-26 09:12 alostale Status acknowledged => scheduled
2015-02-26 09:12 alostale Assigned To AugustoMauch => inigosanchez
2015-02-26 09:12 alostale fix_in_branch => pi
2015-02-26 12:28 inigosanchez Note Added: 0074959
2015-02-26 12:28 inigosanchez Note Edited: 0074959 View Revisions
2015-02-26 12:29 inigosanchez Assigned To inigosanchez => alostale
2015-02-26 12:30 inigosanchez Issue Monitored: inigosanchez
2015-02-27 08:00 alostale Resolution time 1425596400 =>
2015-02-27 08:00 alostale Note Added: 0075007
2015-02-27 08:00 alostale Type defect => design defect
2015-02-27 08:00 alostale Target Version 3.0PR15Q3 =>
2015-02-27 08:00 alostale fix_in_branch pi =>
2015-02-27 08:00 alostale Status scheduled => acknowledged
2017-04-10 14:35 alostale Assigned To alostale => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker