Openbravo Issue Tracking System - Modules
View Issue Details
0039162ModulesExternal Data Integrationpublic2018-08-21 10:082019-06-07 09:51
kchoperena 
kchoperena 
normalmajoralways
closedfixed 
5
 
 
caristu
0039162: [SER-QA 4510]:ImpRove the performance of organization filter in EDL Request window of back-end
It would be nice to have an index in OBEDL_Request table to improve the performance of the organization filter in EDL Request window
1.- Log into the back-end
2.- Open EDL Request window
3.- Filter using the Organization filter

Expected result: Bad performance when we have a lot of registers in OBEDL_Request table
Add a new index for Organization column
No tags attached.
diff edlOrganizationFieldVisible.diff (1,842) 2018-08-23 10:40
https://issues.openbravo.com/file_download.php?file_id=12071&type=bug
Issue History
2018-08-21 10:08kchoperenaNew Issue
2018-08-21 10:08kchoperenaAssigned To => platform
2018-08-21 10:08kchoperenaResolution time => 1535407200
2018-08-21 10:12kchoperenaFile Added: edlOrganizationFieldVisible.diff
2018-08-23 10:31kchoperenaProposed Solution updated
2018-08-23 10:34kchoperenaProposed Solution updated
2018-08-23 10:40kchoperenaFile Deleted: edlOrganizationFieldVisible.diff
2018-08-23 10:40kchoperenaFile Added: edlOrganizationFieldVisible.diff
2019-06-03 15:14kchoperenaSummary[SER-QA 4510]: Show organization column in EDL Request window of back-end => [SER-QA 4510]:ImpRove the performance of organization filter in EDL Request window of back-end
2019-06-03 15:14kchoperenaDescription Updatedbug_revision_view_page.php?rev_id=18865#r18865
2019-06-03 15:14kchoperenaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18867#r18867
2019-06-03 15:14kchoperenaProposed Solution updated
2019-06-03 15:20hgbotCheckin
2019-06-03 15:20hgbotNote Added: 0112340
2019-06-03 15:20hgbotStatusnew => resolved
2019-06-03 15:20hgbotResolutionopen => fixed
2019-06-03 15:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/9717278efcb0a51fb9e594193d3aaf0de94d4d32 [^]
2019-06-03 16:01caristuAssigned Toplatform => kchoperena
2019-06-03 16:02caristuReview Assigned To => caristu
2019-06-07 09:51caristuNote Added: 0112502
2019-06-07 09:51caristuStatusresolved => closed

Notes
(0112340)
hgbot   
2019-06-03 15:20   
Repository: erp/pmods/org.openbravo.externaldata.integration
Changeset: 9717278efcb0a51fb9e594193d3aaf0de94d4d32
Author: Kepa Choperena <kepa.choperena <at> openbravo.com>
Date: Mon Jun 03 15:20:42 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/9717278efcb0a51fb9e594193d3aaf0de94d4d32 [^]

Fixed issue 39162: Added new index for organization column in OBEDL_Request table

---
M src-db/database/model/tables/OBEDL_REQUEST.xml
---
(0112502)
caristu   
2019-06-07 09:51   
Reviewed