Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039554Retail ModulesWeb POSpublic2018-10-29 10:242018-11-05 09:04
Reporteravicente 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039554: Create index to improve performance of delete action in some windows
DescriptionHi,

Could you create the following index please? We need it to improve the performance of delete action in some windows.

CREATE INDEX obpos_orderappr_user ON obpos_order_approval USING btree (ad_user_id) WHERE ad_user_id IS NOT NULL;

Thanks,
Amaya
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsSER-QA
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-10-29 10:24avicenteNew Issue
2018-10-29 10:24avicenteAssigned To => Retail
2018-10-29 10:24avicenteResolution time => 1541545200
2018-10-29 10:24avicenteTriggers an Emergency Pack => No
2018-10-29 10:25avicenteTag Attached: SER-QA
2018-10-30 20:07rqueraltaAssigned ToRetail => rqueralta
2018-10-31 20:29rqueraltaAssigned Torqueralta => avicente
2018-10-31 20:29rqueraltaAssigned Toavicente => rqueralta
2018-10-31 20:29rqueraltaStatusnew => scheduled
2018-11-02 11:17hgbotCheckin
2018-11-02 11:17hgbotNote Added: 0107720
2018-11-02 11:17hgbotStatusscheduled => resolved
2018-11-02 11:17hgbotResolutionopen => fixed
2018-11-02 11:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a4c977259b10fae6e7f281f52d2dcf6f26454266 [^]
2018-11-05 09:04marvintmReview Assigned To => marvintm
2018-11-05 09:04marvintmStatusresolved => closed
2018-11-05 09:04marvintmFixed in Version => RR19Q1

Notes
(0107720)
hgbot   
2018-11-02 11:17   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a4c977259b10fae6e7f281f52d2dcf6f26454266
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Tue Oct 30 09:05:26 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a4c977259b10fae6e7f281f52d2dcf6f26454266 [^]

Fixed issue 39554: Create index to improve performance of delete action in some
windows

---
M src-db/database/model/tables/OBPOS_ORDER_APPROVAL.xml
---