Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013611Openbravo ERP07. Sales managementpublic2010-06-10 16:102011-01-27 10:27
Reporteradrianromero 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP12 
Target Version2.40MP13Fixed in Version 
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
Summary0013611: Inhomogeneous behavior of searchers
DescriptionSearching by "Document No" is case sensitive and searching by "Order Reference" is not case sensitive in, for example, Invoice window.

All fields in Search button should not be case sensitive.
Steps To Reproduce1. Go to Sales Management || Transactions || Sales Invoice || Header :
create record with documentno=300004gh and Order Reference=gh
2. Press Search button and try to find with documentno=%GH --> no record obtained
3. Press Search button and try to find with orderreference=%GH --> 1 record obtained
Proposed Solutionmake all fields in serachers not case sensitive
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00136022.40MP13 closed adrianromero Inhomogeneous behavior of searchers 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-10 16:10adrianromeroNew Issue
2010-06-10 16:10adrianromeroAssigned To => adrianromero
2010-06-10 16:10adrianromeroIssue generated from0013602
2010-06-10 16:10adrianromeroRelationship addedblocks 0013602
2010-06-10 16:10adrianromeroStatusnew => scheduled
2010-06-10 16:10adrianromerofix_in_branch => pi
2010-07-20 18:23hgbotCheckin
2010-07-20 18:23hgbotNote Added: 0029416
2010-07-20 18:23hgbotStatusscheduled => resolved
2010-07-20 18:23hgbotResolutionopen => fixed
2010-07-20 18:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/b4533f12735c11a1e68adbfbad710d7a2161ffc0 [^]
2010-07-20 18:31adrianromeroNote Added: 0029419
2011-01-27 10:27psarobeStatusresolved => closed

Notes
(0029416)
hgbot   
2010-07-20 18:23   
Repository: erp/stable/2.40
Changeset: b4533f12735c11a1e68adbfbad710d7a2161ffc0
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Jul 20 18:23:00 2010 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/b4533f12735c11a1e68adbfbad710d7a2161ffc0 [^]

Fixes issue 0013611: Inhomogeneous behavior of searchers
It has been made all fields case insensitive

---
M src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---
(0029419)
adrianromero   
2010-07-20 18:31   
* Testing of the issue

Searching by documentno or orderreference have exactly the same behavior. Searching by any kind of field is always case insesitive.

* Other areas affected.
It only has been modified the case sensitive search behavior for fields called "documentno" and "value" any other search behaves the same