Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025009Openbravo ERPA. Platformpublic2013-10-24 11:532014-07-22 07:53
Reportercaristu 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0025009: Filters for columns with multiple identifiers are not working properly under some circunstances
DescriptionFilters for columns with multiple identifiers are not working properly when we have more than 100 rows displayed in the grid (when the filtering is not performed locally)
Steps To ReproduceAs system administrator
1) Go to the [Tables and Columns] window and select the BusinessPartner table
2) Look for the Value column and set is as record identifier (We have now two records identifiers: Name and Value)
3) recompile and restart tomcat

As group admin role
4) Create a business partner whose search key is contained in another business partner search key. For example, if we have a business partner with search-key ES-C1/0001, we create:
- Value: ES-C1
- Commercial Name: Alimentos 2
5) Go to the [Sales Order] window, ensure to have more than 100 rows in this window.
6) Create a new sales order for the business partner created in step 4).
7) In grid mode, try to filter by clicking in the checkbox of the filter for the new business partner. Notice that the result of the filtration shows the record for business partner ES-C1 but also all the records for the business partner ES-C1/0001
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on design defect 0025211 closed AugustoMauch Filter by selected value in FK uses identifier instead of ID 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-10-24 11:53caristuNew Issue
2013-10-24 11:53caristuAssigned To => AugustoMauch
2013-10-24 11:53caristuModules => Core
2013-10-24 11:53caristuResolution time => 1385506800
2013-10-24 11:53caristuTriggers an Emergency Pack => No
2013-10-24 11:53caristuIssue Monitored: networkb
2013-10-24 23:59heccamIssue Monitored: heccam
2013-11-04 09:54jonalegriaesarteTarget Version3.0MP30 => 3.0MP31
2013-12-17 10:39alostaleRelationship addedrelated to 0025211
2014-01-02 12:38jonalegriaesarteTarget Version3.0MP31 => 3.0MP32
2014-01-27 16:25alostaleNote Added: 0063723
2014-01-27 16:25alostaleTypedefect => design defect
2014-01-27 16:25alostaleTarget Version3.0MP32 =>
2014-01-27 16:26alostaleRelationship replaceddepends on 0025211
2014-03-11 09:20extraIssue Monitored: extra
2014-07-22 07:53alostaleNote Added: 0068774
2014-07-22 07:53alostaleStatusnew => closed
2014-07-22 07:53alostaleResolutionopen => out of date

Notes
(0063723)
alostale   
2014-01-27 16:25   
Currently multi identifiers are filtered only by their first part, see https://code.openbravo.com/erp/devel/pi/file/9b47b9cdf8c1/modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java#l630 [^]

This issue should be fixed when 0025211 is addressed
(0068774)
alostale   
2014-07-22 07:53   
Fixed by 0025211