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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008972
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2009-05-08 18:582009-07-03 13:15
ReporternetworkbView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision01c2c9482129
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008972: Not possible to use attribute as a filter field

DescriptionThere 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
Steps To Reproducego 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0008999 closedalostale HTTP Status 404 - /obdev/info/AttributeSetValue.html 
related to defect 0009691pi closedshuehner The filter pop-up/search pop-up does not work properly 

-  Notes
(0016217)
pnuding (reporter)
2009-05-11 09:04

Corrected priority to immediate
(0016221)
rafaroda (developer)
2009-05-11 09:13

Please specify the Openbravo ERP version.
(0016275)
rafaroda (developer)
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 (manager)
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 (developer)
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 (reporter)
2009-06-02 13:32

Tested working fine
(0017644)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-05-08 18:58 networkb New Issue
2009-05-08 18:58 networkb Assigned To => rafaroda
2009-05-08 18:58 networkb Regression testing => No
2009-05-11 09:04 pnuding Note Added: 0016217
2009-05-11 09:04 pnuding Priority normal => immediate
2009-05-11 09:13 rafaroda Note Added: 0016221
2009-05-11 09:13 rafaroda Status new => feedback
2009-05-11 16:20 networkb Status feedback => new
2009-05-11 16:20 networkb version => 2.40
2009-05-11 17:52 rafaroda Note Added: 0016275
2009-05-11 17:52 rafaroda Assigned To rafaroda => alostale
2009-05-11 17:52 rafaroda Status new => acknowledged
2009-05-12 09:14 rafaroda Status acknowledged => scheduled
2009-05-12 09:14 rafaroda fix_in_branch => pi
2009-05-12 09:16 alostale Note Added: 0016283
2009-05-14 08:18 alostale fix_in_branch pi =>
2009-05-14 08:18 alostale Summary HTTP Status 404 - /obdev/info/AttributeSetValue.html => Not possible to use attribute as a filter field
2009-05-14 09:50 hgbot Checkin
2009-05-14 09:50 hgbot Note Added: 0016343
2009-05-14 09:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9859ac217a3f32d1758cd212bced2de0d3b3c1b3 [^]
2009-05-14 09:51 alostale Status scheduled => resolved
2009-05-14 09:51 alostale Fixed in Version => pi
2009-05-14 09:51 alostale Resolution open => fixed
2009-06-02 13:32 sureshbabu Status resolved => closed
2009-06-02 13:32 sureshbabu Note Added: 0016866
2009-06-03 00:00 anonymous sf_bug_id 0 => 2800235
2009-06-29 14:36 shuehner Relationship added related to 0009691
2009-06-29 16:05 hgbot Checkin
2009-06-29 16:05 hgbot Note Added: 0017644
2009-06-29 16:05 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/9859ac217a3f32d1758cd212bced2de0d3b3c1b3 [^] => http://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^]
2009-07-03 13:15 hgbot Checkin
2009-07-03 13:15 hgbot Note Added: 0017887
2009-07-03 13:15 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^] => http://code.openbravo.com/erp/devel/pi/rev/01c2c9482129feccaa2388ad2dc930f1b8a5d8ab [^]


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker