Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038713Openbravo ERP07. Sales managementpublic2018-06-06 17:302018-06-11 15:32
ReporterSandrahuguet 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version3.0PR18Q3 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038713: Change to partial index c_invoiceline_account index
DescriptionAfter DMI and SHUG review c_invoiceline_account index should be changed to partial index
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on feature request 0035205 closed vmromanos define partial indexes for not null values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-06-06 17:30SandrahuguetNew Issue
2018-06-06 17:30SandrahuguetAssigned To => Triage Finance
2018-06-06 17:30SandrahuguetOBNetwork customer => No
2018-06-06 17:30SandrahuguetModules => Core
2018-06-06 17:30SandrahuguetTriggers an Emergency Pack => No
2018-06-06 17:32SandrahuguetSeveritytrivial => minor
2018-06-07 16:28SandrahuguetRelationship addeddepends on 0035205
2018-06-08 08:55dmiguelezAssigned ToTriage Finance => AtulOpenbravo
2018-06-08 16:16AtulOpenbravoStatusnew => scheduled
2018-06-11 11:29hgbotCheckin
2018-06-11 11:29hgbotNote Added: 0105054
2018-06-11 11:29hgbotStatusscheduled => resolved
2018-06-11 11:29hgbotResolutionopen => fixed
2018-06-11 11:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d78d99fe93f434f7a29893cdd9ca745014c640f8 [^]
2018-06-11 11:30dmiguelezReview Assigned To => dmiguelez
2018-06-11 11:30dmiguelezNote Added: 0105056
2018-06-11 11:30dmiguelezStatusresolved => closed
2018-06-11 11:30dmiguelezFixed in Version => 3.0PR18Q3
2018-06-11 15:32hudsonbotCheckin
2018-06-11 15:32hudsonbotNote Added: 0105063

Notes
(0105054)
hgbot   
2018-06-11 11:29   
Repository: erp/devel/pi
Changeset: d78d99fe93f434f7a29893cdd9ca745014c640f8
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Jun 08 15:41:07 2018 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d78d99fe93f434f7a29893cdd9ca745014c640f8 [^]

Fixes Issue 0038713: Change to partial index c_invoiceline_account
index

Use partial index for column ACCOUNT_ID in table C_INVOICELINE

---
M src-db/database/model/tables/C_INVOICELINE.xml
---
(0105056)
dmiguelez   
2018-06-11 11:30   
Code Review + Testing Ok
(0105063)
hudsonbot   
2018-06-11 15:32   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8ec79fef1c3a [^]
Maturity status: Test