Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0019013 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] B. User interface | minor | always | 2011-11-08 09:37 | 2011-11-30 16:20 | |||
| Reporter | RenateNieuwkoop | View Status | public | |||||
| Assigned To | mtaal | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0MP6 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 156cf2dff878 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP6 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP4.1 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0019013: Filter on Account Schema Tables is not working okay | |||||||
| Description | In 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 Reproduce | Go 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  IssuefilterAcctables1.png [^] (119,747 bytes) 2011-11-08 09:37
IssuefilterAcctables2.png [^] (86,260 bytes) 2011-11-08 09:37
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0042674) mtaal (viewer) 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 (viewer) 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 (viewer) 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 (administrator) 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. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |