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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0019013
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] B. User interfaceminoralways2011-11-08 09:372011-11-30 16:20
ReporterRenateNieuwkoopView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in Version3.0MP6
StatusclosedFix in branchFixed in SCM revision156cf2dff878
ProjectionnoneETAnoneTarget Version3.0MP6
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP4.1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019013: 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
TagsNo tags attached.
Attached Filespng file icon IssuefilterAcctables1.png [^] (119,747 bytes) 2011-11-08 09:37


png file icon IssuefilterAcctables2.png [^] (86,260 bytes) 2011-11-08 09:37

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0042674)
mtaal (manager)
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 (manager)
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 (developer)
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 (developer)
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 (manager)
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.

- Issue History
Date Modified Username Field Change
2011-11-08 09:37 RenateNieuwkoop New Issue
2011-11-08 09:37 RenateNieuwkoop Assigned To => dbaz
2011-11-08 09:37 RenateNieuwkoop File Added: IssuefilterAcctables1.png
2011-11-08 09:37 RenateNieuwkoop Modules => Core
2011-11-08 09:37 RenateNieuwkoop File Added: IssuefilterAcctables2.png
2011-11-08 10:20 dbaz Assigned To dbaz => mtaal
2011-11-08 10:20 dbaz Target Version => 3.0MP6
2011-11-08 13:01 mtaal Note Added: 0042674
2011-11-08 13:03 mtaal Note Added: 0042675
2011-11-08 20:44 hgbot Checkin
2011-11-08 20:44 hgbot Note Added: 0042680
2011-11-08 20:44 hgbot Status new => resolved
2011-11-08 20:44 hgbot Resolution open => fixed
2011-11-08 20:44 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/156cf2dff87892d274d06352932255593cc56db6 [^]
2011-11-12 15:48 hudsonbot Checkin
2011-11-12 15:48 hudsonbot Note Added: 0042784
2011-11-30 16:20 AugustoMauch Note Added: 0043588
2011-11-30 16:20 AugustoMauch Status resolved => closed
2011-11-30 16:20 AugustoMauch Fixed in Version => 3.0MP6


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker