Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009550Openbravo ERPA. Platformpublic2009-06-18 18:132009-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
Summary0009550: Use the new ignoreValues features of sqlc to speed up filters with value '%'
DescriptionUse the new ignore values feature to speed up queries using '%' as filter value.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0009549 closed shuehner Use the new ignoreValues features of sqlc to speed up filters with value '%' 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-18 18:14shuehnerTypefeature request => backport
2009-06-18 18:14shuehnerfix_in_branch => 2.40
2009-06-19 12:04hgbotCheckin
2009-06-19 12:04hgbotNote Added: 0017464
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/3a9e7a9859b18e3e18bff006fefa2f671bfe7e9b [^]
2009-06-22 07:08sureshbabuStatusresolved => closed
2009-06-22 07:08sureshbabuNote Added: 0017495
2009-06-22 07:08sureshbabuFixed in Version => 2.40MP7

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

Fixed 9550: Use the new ignoreValue feature of Sqlc to speed up queries with value '%'

---
M src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql
M src/org/openbravo/erpCommon/info/Account.java
M src/org/openbravo/erpCommon/info/AccountElementValue.java
M src/org/openbravo/erpCommon/info/AccountElementValue_data.xsql
M src/org/openbravo/erpCommon/info/Account_data.xsql
M src/org/openbravo/erpCommon/info/BusinessPartner.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
M src/org/openbravo/erpCommon/info/DebtPayment_data.xsql
M src/org/openbravo/erpCommon/info/ImageInfo_data.xsql
M src/org/openbravo/erpCommon/info/Invoice.java
M src/org/openbravo/erpCommon/info/InvoiceLine.java
M src/org/openbravo/erpCommon/info/InvoiceLine_data.xsql
M src/org/openbravo/erpCommon/info/Invoice_data.xsql
M src/org/openbravo/erpCommon/info/Locator_data.xsql
M src/org/openbravo/erpCommon/info/ProductComplete.java
M src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
M src/org/openbravo/erpCommon/info/ProductMultiple_data.xsql
M src/org/openbravo/erpCommon/info/Product_data.xsql
M src/org/openbravo/erpCommon/info/Project_data.xsql
M src/org/openbravo/erpCommon/info/SalesOrder.java
M src/org/openbravo/erpCommon/info/SalesOrderLine.java
M src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
M src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
M src/org/openbravo/erpCommon/info/ShipmentReceiptLine_data.xsql
M src/org/openbravo/erpCommon/info/ShipmentReceipt_data.xsql
---
(0017495)
sureshbabu   
2009-06-22 07:08   
Tested working fine