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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023169
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2013-02-26 18:172013-03-13 14:44
ReportercaristuView Statuspublic 
Assigned ToAugustoMauch 
PriorityhighResolutionfixedFixed in Version3.0MP22
StatusclosedFix in branchFixed in SCM revisionfda718bfd935
ProjectionnoneETAnoneTarget Version3.0MP22
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Toshankarb
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023169: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00235303.0MP23 closedmtaal Filtering with a multiple value is not working properly 

-  Notes
(0057138)
caristu (developer)
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 (developer)
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 (manager)
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 (reporter)
2013-03-13 14:44

Code reviewed and tested in pi changeset 4b43f5a6429b

- Issue History
Date Modified Username Field Change
2013-02-26 18:17 caristu New Issue
2013-02-26 18:17 caristu Assigned To => AugustoMauch
2013-02-26 18:17 caristu Modules => Core
2013-02-26 18:17 caristu Resolution time => 1368396000
2013-02-26 18:17 caristu Triggers an Emergency Pack => No
2013-02-26 18:17 caristu Issue Monitored: networkb
2013-03-06 19:00 caristu Steps to Reproduce Updated View Revisions
2013-03-06 19:01 caristu Steps to Reproduce Updated View Revisions
2013-03-07 13:44 shankarb Assigned To AugustoMauch => shankarb
2013-03-07 13:52 caristu Note Added: 0057138
2013-03-07 13:53 caristu Note Edited: 0057138 View Revisions
2013-03-11 09:48 AugustoMauch Assigned To shankarb => AugustoMauch
2013-03-11 11:39 AugustoMauch Issue Monitored: shankarb
2013-03-11 11:40 AugustoMauch Review Assigned To => shankarb
2013-03-11 11:41 hgbot Checkin
2013-03-11 11:41 hgbot Note Added: 0057175
2013-03-11 11:41 hgbot Status new => resolved
2013-03-11 11:41 hgbot Resolution open => fixed
2013-03-11 11:41 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fda718bfd9355e2e7e77cd0fb87a1b89bcead284 [^]
2013-03-11 11:42 AugustoMauch Note Added: 0057176
2013-03-13 14:44 shankarb Note Added: 0057229
2013-03-13 14:44 shankarb Status resolved => closed
2013-03-13 14:44 shankarb Fixed in Version => 3.0MP22
2013-04-10 17:24 caristu Relationship added related to 0023530


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker