Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020499Openbravo ERPA. Platformpublic2012-05-14 18:472012-08-22 09:36
mirurita 
migueldejuana 
normalminoralways
closedfixed 
5
pi 
3.0MP15 
AugustoMauch
Core
No
0020499: Error when filtering in "Transaction" selector on Match Statement popup
Filtering functionality in "Transaction" selector on Match Statement popup it's working fine.

But every time the selector is doing a filtering request (i.e. the user enters a new string in Description field) in the backend an error is registered.

The selector it's trying to resolve a "Command" property for FIN_Finacc_Transaction entity, but this property does not exist.

Failing also on MP10.2.

*************** Client Request ***************
_selectorDefinitionId:6643B422022B41698FEFD6C7FAD7AC4B
...
_constructor:AdvancedCriteria
criteria:{"operator":"iContains","fieldName":"Command","value":""}

*************** org.openbravo.userinterface.selector.SelectorDataSourceFilter ***************
// A property in the entity is searched for this fieldName
// If the property is numeric or date, then it is filtered
String[] fieldNameSplit = fieldName.split("\\.");
Property fProp = null;
if (fieldNameSplit.length == 1) {
  fProp = entity.getProperty(fieldName);
} else {

*************** Error ***************
2561261 [TP-Processor6] ERROR org.openbravo.base.util.CheckException - Property Command does not exist for entity FIN_Finacc_Transaction
org.openbravo.base.util.CheckException: Property Command does not exist for entity FIN_Finacc_Transaction
    at org.openbravo.base.util.Check.isNotNull(Check.java:72)
    at org.openbravo.base.model.Entity.getProperty(Entity.java:452)
    at org.openbravo.userinterface.selector.SelectorDataSourceFilter.verifyPropertyTypes(SelectorDataSourceFilter.java:161)
    at org.openbravo.userinterface.selector.SelectorDataSourceFilter.doFilter(SelectorDataSourceFilter.java:98)
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:190)
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:575)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
1) Go to "Financial Account"
2) Select record "Bank - Account 2"
3) In form mode do this change: Matching Algorithm -> Standard
4) Now go to its child tab "Imported Bank Statement"
5) Create new one and fill
   Name: "test"
6) Now go to its child tab "Bank Statement Lines"
7) Create new one and fill
   Reference No: Line1
   Amout IN: 10
8) Create new one and fill
   Reference No: Line2
   Amout IN: 20
9) Click button "Process"
10) Click on "Add Transaction" button
11) Select "Fee" Transaction Type combo
12) Enter 5 on received in field
13) Click on OK button
14) Click button "Match Statement"
15) Click the magnifier glass icon.
16) Filter Description column: type "Fee"
17) You will get an error in the backend

The grid opens, enter a date in the first column, when you tab out the date is changed to the current date.
No tags attached.
Issue History
2012-05-14 18:47miruritaNew Issue
2012-05-14 18:47miruritaAssigned To => alostale
2012-05-14 18:47miruritaModules => Core
2012-08-14 11:06AugustoMauchAssigned Toalostale => AugustoMauch
2012-08-20 08:32AugustoMauchAssigned ToAugustoMauch => migueldejuana
2012-08-21 08:41hgbotCheckin
2012-08-21 08:41hgbotNote Added: 0051414
2012-08-21 08:41hgbotStatusnew => resolved
2012-08-21 08:41hgbotResolutionopen => fixed
2012-08-21 08:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc375f70dce943e8a08c0b92c8caf7cf40941878 [^]
2012-08-22 09:36AugustoMauchClosed by => AugustoMauch
2012-08-22 09:36AugustoMauchNote Added: 0051444
2012-08-22 09:36AugustoMauchStatusresolved => closed
2012-08-22 09:36AugustoMauchFixed in Version => 3.0MP15

Notes
(0051414)
hgbot   
2012-08-21 08:41   
Repository: erp/devel/pi
Changeset: cc375f70dce943e8a08c0b92c8caf7cf40941878
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Tue Aug 21 08:40:26 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cc375f70dce943e8a08c0b92c8caf7cf40941878 [^]

Fixed issue 20499: In classicWindow,validate properties to get when filtering

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorDataSourceFilter.java
---
(0051444)
AugustoMauch   
2012-08-22 09:36   
Code reviewed and verified in pi@fb014b417c71