Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033690Retail ModulesWeb POSpublic2016-08-11 14:132016-11-07 14:25
ReporterOrekaria 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033690: With big data, searching for a receipt is slow
DescriptionWith big data, searching for a receipt is slow
Steps To ReproduceIn a context with large amount of receipts

Create a OBPOS_remote.receipt_usesContains preference with value 'N'

In the menu
Select Receipts
When the popup is opened, try to search for a receipt introducing the firs 3 numbers
Verify that the query takes longer than 1 second

Verify that the query created in PaidReceiptsHeader.java, adds the business partner name to the query. See attached patch
Proposed SolutionA preference could be created not to remove the business partner name in the query
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0033044 closed Sandrahuguet [HGVOL] Remote tickets search should be configurable to use contains or startswith with a preference 
Attached Filespatch 4918.patch (1,211) 2016-08-13 09:57
https://issues.openbravo.com/file_download.php?file_id=9716&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-08-11 14:13OrekariaNew Issue
2016-08-11 14:13OrekariaAssigned To => Retail
2016-08-11 14:13OrekariaOBNetwork customer => No
2016-08-11 14:13OrekariaTriggers an Emergency Pack => No
2016-08-11 14:42OrekariaOBNetwork customerNo => Yes
2016-08-11 14:42OrekariaResolution time => 1475272800
2016-08-13 09:57OrekariaFile Added: 4918.patch
2016-08-18 14:10OrekariaRelationship addeddepends on 0033044
2016-08-18 14:10shuehnerIssue Monitored: shuehner
2016-10-03 11:16marvintmResolution time1475272800 => 1476482400
2016-10-10 10:54marvintmResolution time1476482400 =>
2016-10-10 10:54marvintmTypedefect => design defect
2016-10-13 17:32mario_castelloAssigned ToRetail => mario_castello
2016-10-13 17:32mario_castelloStatusnew => acknowledged
2016-11-07 14:25mario_castelloAssigned Tomario_castello => Retail

There are no notes attached to this issue.