Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009547 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] A. Platform | minor | have not tried | 2009-06-18 16:19 | 2009-06-22 07:08 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40MP7 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 1e1a9652a6d7 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009547: Add feature to ignore the value '%' in select which use like | |||||||
| Description | The 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 Solution | Add 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). | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0017463) hgbot (developer) 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 (reporter) 2009-06-22 07:08 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-18 16:20 | shuehner | Type | feature request => backport |
| 2009-06-18 16:20 | shuehner | fix_in_branch | => 2.40 |
| 2009-06-19 12:04 | hgbot | Checkin | |
| 2009-06-19 12:04 | hgbot | Note Added: 0017463 | |
| 2009-06-19 12:04 | hgbot | Status | scheduled => resolved |
| 2009-06-19 12:04 | hgbot | Resolution | open => fixed |
| 2009-06-19 12:04 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/1e1a9652a6d7324ac35ff2ca6ca9b93d6074906f [^] |
| 2009-06-22 07:08 | sureshbabu | Status | resolved => closed |
| 2009-06-22 07:08 | sureshbabu | Note Added: 0017496 | |
| 2009-06-22 07:08 | sureshbabu | Fixed in Version | => 2.40MP7 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |