Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023169Openbravo ERP00. Application dictionarypublic2013-02-26 18:172013-03-13 14:44
Reportercaristu 
Assigned ToAugustoMauch 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP22Fixed in Version3.0MP22 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023169: Dropdown column filters are not working properly with table reference
DescriptionIf we create a column with table reference, its drop-down filter is not working fine as it is necessary to choose two values to apply the filter.
Steps To Reproduce1) Use or add a new field in a window, which is related to a column that uses a Table reference. The table used in the window, must have two or more columns marked as record identifier
2) Use the drop-down filter of the field, and select just one value. Notice that the filter is not applied.
3) Select two or more values in the filter. Notice that the filter is applied.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00235303.0MP23 closed mtaal Filtering with a multiple value is not working properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-26 18:17caristuNew Issue
2013-02-26 18:17caristuAssigned To => AugustoMauch
2013-02-26 18:17caristuModules => Core
2013-02-26 18:17caristuResolution time => 1368396000
2013-02-26 18:17caristuTriggers an Emergency Pack => No
2013-02-26 18:17caristuIssue Monitored: networkb
2013-03-06 19:00caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4473#r4473
2013-03-06 19:01caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4474#r4474
2013-03-07 13:44shankarbAssigned ToAugustoMauch => shankarb
2013-03-07 13:52caristuNote Added: 0057138
2013-03-07 13:53caristuNote Edited: 0057138bug_revision_view_page.php?bugnote_id=0057138#r4486
2013-03-11 09:48AugustoMauchAssigned Toshankarb => AugustoMauch
2013-03-11 11:39AugustoMauchIssue Monitored: shankarb
2013-03-11 11:40AugustoMauchReview Assigned To => shankarb
2013-03-11 11:41hgbotCheckin
2013-03-11 11:41hgbotNote Added: 0057175
2013-03-11 11:41hgbotStatusnew => resolved
2013-03-11 11:41hgbotResolutionopen => fixed
2013-03-11 11:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fda718bfd9355e2e7e77cd0fb87a1b89bcead284 [^]
2013-03-11 11:42AugustoMauchNote Added: 0057176
2013-03-13 14:44shankarbNote Added: 0057229
2013-03-13 14:44shankarbStatusresolved => closed
2013-03-13 14:44shankarbFixed in Version => 3.0MP22
2013-04-10 17:24caristuRelationship addedrelated to 0023530

Notes
(0057138)
caristu   
2013-03-07 13:52   
(edited on: 2013-03-07 13:53)
Steps to create the field to filter:

1) Create a new column for a table (for example c_order): ALTER TABLE c_order ADD COLUMN em_moduledbprefix_test VARCHAR(32);
As system admin:
2) Go to [Tables and Columns] and add the new field for the c_order table. Put "Table" as reference and "C_Bpartner" as reference search key.
3) Still in [Tables and Columns] go to "C_Bpartner" table and check off the "used as Record Identifier" checkbox in the "Value" column. At this moment, we'll have two columns selected as record identifier.
4) In [Windows, Tabs and Fields] add the new field for the Sales Order header.
5) ant smartbuild
As group admin:
6) In the [Sales Order] window, fill the recently created field for two different sales orders with two different values.
(0057175)
hgbot   
2013-03-11 11:41   
Repository: erp/devel/pi
Changeset: fda718bfd9355e2e7e77cd0fb87a1b89bcead284
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Mar 11 11:38:39 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fda718bfd9355e2e7e77cd0fb87a1b89bcead284 [^]

Fixes issue 23169: Dropdown filters work working properly with table reference

In MP17 the advanced filter for dropdown list references was introduced. Before that change, it was needed to remove a duplicated criteria for foreign key references whose identifier was composed of more than one field. This removal is no longer needed.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
---
(0057176)
AugustoMauch   
2013-03-11 11:42   
Test plan:
- Check that if the steps to reproduce are followed the issue no longer happens
- In that same column filter, instead of selection an option in the dropdown, write part of the name of a business partner and tab out. Check that the filter is also applied.
(0057229)
shankarb   
2013-03-13 14:44   
Code reviewed and tested in pi changeset 4b43f5a6429b