Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009545 | Openbravo ERP | A. Platform | public | 2009-06-18 16:19 | 2009-07-16 17:55 |
|
| Reporter | shuehner | |
| Assigned To | shuehner | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| 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.
|
| Steps To Reproduce | |
| 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). |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0009547 | | closed | shuehner | Add feature to ignore the value '%' in select which use like |
|
| Attached Files | |
|
| 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 |