Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030827Openbravo ERP09. Financial managementpublic2015-09-15 14:202015-12-21 16:17
Reportervmromanos 
Assigned ToTriage Omni OMS 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030827: Review ReportGeneralLedgerJournalData subqueries related to account from and to
DescriptionThe ReportGeneralLedgerJournalData has 3 queries that run a subquery to filter by account from and to: select, selectCountGroupedLines, selectCount.

These subqueries have some filters in the where clause that might be useless because the same filters are run in the parent query: dateacct, client, org.

Besides they use IN clause, which might create problems in Oracle.

Steps To ReproduceNA
Proposed SolutionReview these subqueries and try to improve them:
+ Remove useless filters
+ Try to use EXISTS instead of IN
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0027034 closed rafademiguel Add From/To Account filters to Journal Entries Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-09-15 14:20vmromanosNew Issue
2015-09-15 14:20vmromanosAssigned To => Triage Finance
2015-09-15 14:20vmromanosOBNetwork customer => No
2015-09-15 14:20vmromanosModules => Core
2015-09-15 14:20vmromanosTriggers an Emergency Pack => No
2015-09-15 14:21vmromanosRelationship addedrelated to 0027034
2015-12-21 16:17vmromanosTarget Version3.0PR16Q1 =>

There are no notes attached to this issue.