Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009547Openbravo ERPA. Platformpublic2009-06-18 16:192009-06-22 07:08
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.40MP7 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009547: 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.

Steps To Reproduce
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).
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0009545 closed shuehner Add feature to ignore the value '%' in select which use like 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-18 16:20shuehnerTypefeature request => backport
2009-06-18 16:20shuehnerfix_in_branch => 2.40
2009-06-19 12:04hgbotCheckin
2009-06-19 12:04hgbotNote Added: 0017463
2009-06-19 12:04hgbotStatusscheduled => resolved
2009-06-19 12:04hgbotResolutionopen => fixed
2009-06-19 12:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/1e1a9652a6d7324ac35ff2ca6ca9b93d6074906f [^]
2009-06-22 07:08sureshbabuStatusresolved => closed
2009-06-22 07:08sureshbabuNote Added: 0017496
2009-06-22 07:08sureshbabuFixed in Version => 2.40MP7

Notes
(0017463)
hgbot   
2009-06-19 12:04   
Repository: erp/stable/2.40
Changeset: 1e1a9652a6d7324ac35ff2ca6ca9b93d6074906f
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 18 16:24:33 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/1e1a9652a6d7324ac35ff2ca6ca9b93d6074906f [^]

Fixed 9547: 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
- Reformat Sqlc to be more similar to pi

---
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
---
(0017496)
sureshbabu   
2009-06-22 07:08   
Tested working fine