Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019013Openbravo ERPB. User interfacepublic2011-11-08 09:372011-11-30 16:20
ReporterRenateNieuwkoop 
Assigned Tomtaal 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP4.1 
Target Version3.0MP6Fixed in Version3.0MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019013: Filter on Account Schema Tables is not working okay
DescriptionIn the latest build of today (as well as previous versions such as 4.1) the filter on the Account Schema Tables does not work correctly

When you enter an 'M' in the filter, you see a list of values, including MaterialMgmt.... However, when you change the filter to 'Ma' the values for the MaterialMgmt... do not appear anymore. See screenshots
Steps To ReproduceGo to the Accounting Schema screen and select F&B US, Inc. US/A/US Dollar (or the F&B International Group US/A/Euro) and go to the Account Schema Tables tab. First enter M in the filter, then Ma. In the case of the Ma, the Material.. tables do not appear
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng IssuefilterAcctables1.png (119,747) 2011-11-08 09:37
https://issues.openbravo.com/file_download.php?file_id=4730&type=bug
png

png IssuefilterAcctables2.png (86,260) 2011-11-08 09:37
https://issues.openbravo.com/file_download.php?file_id=4731&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-11-08 09:37RenateNieuwkoopNew Issue
2011-11-08 09:37RenateNieuwkoopAssigned To => dbaz
2011-11-08 09:37RenateNieuwkoopFile Added: IssuefilterAcctables1.png
2011-11-08 09:37RenateNieuwkoopModules => Core
2011-11-08 09:37RenateNieuwkoopFile Added: IssuefilterAcctables2.png
2011-11-08 10:20dbazAssigned Todbaz => mtaal
2011-11-08 10:20dbazTarget Version => 3.0MP6
2011-11-08 13:01mtaalNote Added: 0042674
2011-11-08 13:03mtaalNote Added: 0042675
2011-11-08 20:44hgbotCheckin
2011-11-08 20:44hgbotNote Added: 0042680
2011-11-08 20:44hgbotStatusnew => resolved
2011-11-08 20:44hgbotResolutionopen => fixed
2011-11-08 20:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/156cf2dff87892d274d06352932255593cc56db6 [^]
2011-11-12 15:48hudsonbotCheckin
2011-11-12 15:48hudsonbotNote Added: 0042784
2011-11-30 16:20AugustoMauchNote Added: 0043588
2011-11-30 16:20AugustoMauchStatusresolved => closed
2011-11-30 16:20AugustoMauchFixed in Version => 3.0MP6

Notes
(0042674)
mtaal   
2011-11-08 13:01   
this is caused by the fact that this column has a table reference, the displayed column is the table name while the filtering occurs on the dbtablename.

To solve this the AdvancedQueryBuilder has to filter on the display column of the table reference.

gr. Martin
(0042675)
mtaal   
2011-11-08 13:03   
To test other table references:
- go to tables and columns and change the identifier of the currency table from isocode to description
- restart
- in the conversionrate window check that the filtering and editing all work and use the iso code and not the description
(0042680)
hgbot   
2011-11-08 20:44   
Repository: erp/devel/pi
Changeset: 156cf2dff87892d274d06352932255593cc56db6
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Nov 08 13:11:07 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/156cf2dff87892d274d06352932255593cc56db6 [^]

Fixes issue 19013: Filter on Account Schema Tables is not working okay

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0042784)
hudsonbot   
2011-11-12 15:48   
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/9752fe729257 [^]

Maturity status: Test
(0043588)
AugustoMauch   
2011-11-30 16:20   
Test plan:
- Open the Account Schema window
- In the filter of the Table field of the Accounting Schema Tables view, enter the name of the table -> The records referencing that table should be filtered
- In the same filter, enter the name of the table in the database -> No records should fulfill the condition, unless its table name is the same as its table name in the database.