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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

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 Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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