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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009545
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2009-06-18 16:192009-07-16 17:55
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision8a460ec42ad8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009545: Add feature to ignore the value '%' in select which use like

DescriptionThe default value for a lot of search fields in openbravo is '%'. When this value is used with like this filter like '%' is redundant and should be removed to increase performance. Especially in combination with the c_ignore_accent function this can lead to a huge performance improvement.

Proposed SolutionAdd a new optional attribute to the parameter definition of xsql files. When not specified then the generated should be identical to the state now. When the new attribute is specified with i.e. the value '%', then at runtime when the filter is '%' the parameter should be treated as "" (and is automatically omitted from the query).
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0009547 closedshuehner Add feature to ignore the value '%' in select which use like 

-  Notes
(0017428)
hgbot (developer)
2009-06-18 16:23

Repository: erp/devel/pi
Changeset: 8a460ec42ad89c98ebc69658cc2938aa41c75fa2
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 18 16:22:45 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8a460ec42ad89c98ebc69658cc2938aa41c75fa2 [^]

Fixed 9545: New feature for Sqlc: ignoreValues
- This adds a new optional attribute to parameter tags in xsql files
- Behavior is unchanged when not specifying this attribute

---
M src-core/src/org/openbravo/data/Parameter.java
M src-core/src/org/openbravo/data/Sql.java
M src-core/src/org/openbravo/data/Sqlc.java
---

- Issue History
Date Modified Username Field Change
2009-06-18 16:19 shuehner New Issue
2009-06-18 16:19 shuehner Assigned To => shuehner
2009-06-18 16:20 shuehner Status new => scheduled
2009-06-18 16:20 shuehner fix_in_branch => pi
2009-06-18 16:23 hgbot Checkin
2009-06-18 16:23 hgbot Note Added: 0017428
2009-06-18 16:23 hgbot Status scheduled => resolved
2009-06-18 16:23 hgbot Resolution open => fixed
2009-06-18 16:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8a460ec42ad89c98ebc69658cc2938aa41c75fa2 [^]
2009-07-11 08:22 pjuvara Status resolved => closed
2009-07-16 17:55 anonymous sf_bug_id 0 => 2822569


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker