Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008972Openbravo ERP04. Warehouse managementpublic2009-05-08 18:582009-07-03 13:15
networkb 
alostale 
immediateminoralways
closedfixed 
20rPath Linux
2.40 
pi 
Core
No
0008972: Not possible to use attribute as a filter field
There is a need to add additional filters to the Goods Transaction window. These are Bin, Product and Attribute Set
Value. This was done by logging in as System Administrator going to the m_transaction table and checking the Filter
Column checkbox for the three columns needed and followed by ant compile.development.

The Product and Bin lookups work correctly. However the Attribute lookup issues the following error.

HTTP Status 404 - /obdev/info/AttributeSetValue.html
go to : Application Dictionary || Windows, Tabs, and Fields || Window (Goods Transaction) Tab / Field choose Product then click on 'Column link'
- then check 'Filter Column'.
Do the same with Attribute Set Value and Storage Bin.
- Then go to: Warehouse Management || Transactions || Goods Transaction || Goods Transaction.
  click on search record.And in the Attribute Set Value we have the 404 error.
No tags attached.
depends on backport 0008999 closed alostale HTTP Status 404 - /obdev/info/AttributeSetValue.html 
related to defect 0009691pi closed shuehner The filter pop-up/search pop-up does not work properly 
Issue History
2009-05-08 18:58networkbNew Issue
2009-05-08 18:58networkbAssigned To => rafaroda
2009-05-08 18:58networkbRegression testing => No
2009-05-11 09:04pnudingNote Added: 0016217
2009-05-11 09:04pnudingPrioritynormal => immediate
2009-05-11 09:13rafarodaNote Added: 0016221
2009-05-11 09:13rafarodaStatusnew => feedback
2009-05-11 16:20networkbStatusfeedback => new
2009-05-11 16:20networkbversion => 2.40
2009-05-11 17:52rafarodaNote Added: 0016275
2009-05-11 17:52rafarodaAssigned Torafaroda => alostale
2009-05-11 17:52rafarodaStatusnew => acknowledged
2009-05-12 09:14rafarodaStatusacknowledged => scheduled
2009-05-12 09:14rafarodafix_in_branch => pi
2009-05-12 09:16alostaleNote Added: 0016283
2009-05-14 08:18alostalefix_in_branchpi =>
2009-05-14 08:18alostaleSummaryHTTP Status 404 - /obdev/info/AttributeSetValue.html => Not possible to use attribute as a filter field
2009-05-14 09:50hgbotCheckin
2009-05-14 09:50hgbotNote Added: 0016343
2009-05-14 09:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9859ac217a3f32d1758cd212bced2de0d3b3c1b3 [^]
2009-05-14 09:51alostaleStatusscheduled => resolved
2009-05-14 09:51alostaleFixed in Version => pi
2009-05-14 09:51alostaleResolutionopen => fixed
2009-06-02 13:32sureshbabuStatusresolved => closed
2009-06-02 13:32sureshbabuNote Added: 0016866
2009-06-03 00:00anonymoussf_bug_id0 => 2800235
2009-06-29 14:36shuehnerRelationship addedrelated to 0009691
2009-06-29 16:05hgbotCheckin
2009-06-29 16:05hgbotNote Added: 0017644
2009-06-29 16:05hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9859ac217a3f32d1758cd212bced2de0d3b3c1b3 [^] => http://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^]
2009-07-03 13:15hgbotCheckin
2009-07-03 13:15hgbotNote Added: 0017887
2009-07-03 13:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^] => http://code.openbravo.com/erp/devel/pi/rev/01c2c9482129feccaa2388ad2dc930f1b8a5d8ab [^]

Notes
(0016217)
pnuding   
2009-05-11 09:04   
Corrected priority to immediate
(0016221)
rafaroda   
2009-05-11 09:13   
Please specify the Openbravo ERP version.
(0016275)
rafaroda   
2009-05-11 17:52   
The issue has been reproducible: platform team is thinking about a proper solution.

Please notice that Attribute selector is quite special (as Location/Address and Accounts Combination) ones.
(0016283)
alostale   
2009-05-12 09:16   
The problem is that attribute search is not just for search info but it also inserts data, that's why it is not possible to use it within a filter.

The same case happens with location search.

Proposed solution: for these two cases do not use the standard search in the filter but use a text box to just to search in the name.
(0016343)
hgbot   
2009-05-14 09:50   
Repository: erp/devel/pi
Changeset: 9859ac217a3f32d1758cd212bced2de0d3b3c1b3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu May 14 08:18:39 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9859ac217a3f32d1758cd212bced2de0d3b3c1b3 [^]

issue 0008972: Not possible to use attribute as a filter field
fixed attribute set instance reference for filters

---
M src/org/openbravo/erpCommon/businessUtility/Buscador.java
M src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---
(0016866)
sureshbabu   
2009-06-02 13:32   
Tested working fine
(0017644)
hgbot   
2009-06-29 16:05   
Repository: erp/devel/pi
Changeset: 7f9b17719565283e4ed51468f58e46e1f830a021
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 29 16:05:18 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^]

Fixed 9691: Fixes The filter pop-up/search pop-up does not work properly
- Reintroduce optimization to optimize away % for where clauses with like and c_ignore_accent
- This optimization was lost acciedently in commit for issue 8972
- This works around 9459

---
M src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---
(0017887)
hgbot   
2009-07-03 13:15   
Repository: erp/devel/pi
Changeset: 01c2c9482129feccaa2388ad2dc930f1b8a5d8ab
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 29 16:05:18 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/01c2c9482129feccaa2388ad2dc930f1b8a5d8ab [^]

Fixed 9691: Fixes The filter pop-up/search pop-up does not work properly
- Reintroduce optimization to optimize away % for where clauses with like and c_ignore_accent
- This optimization was lost acciedently in commit for issue 8972
- This works around 9459

---
M src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---