Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009545 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] A. Platform | minor | have not tried | 2009-06-18 16:19 | 2009-07-16 17:55 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 8a460ec42ad8 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009545: 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 |
|
|
(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 --- |
|
Notes |
|
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:19 | shuehner | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |