Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2020-02-04 10:062020-02-07 14:21
Reporterinigo_lergaView Statuspublic 
Assigned Toinigo_lerga 
PrioritynormalResolutionfixedFixed in Version3.0PR20Q2
StatusclosedFix in branchFixed in SCM revision321d0d9d12be
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0043107: Apply new HQL Style in has two HQL queries with:
- the HQL is hard to read because of formatting
- and it is mixing txt and i.e PROPERTY_ID constant which is not recommended by default
Steps To Reproduce-
Proposed SolutionFollow new format as in [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0041287 acknowledgedplatform Tracking issue: Convert HQL to apply new style 

-  Notes
inigo_lerga (developer)
2020-02-04 10:59

Test Plan Mantis HQL queries:
As the F&B International Group Admin role:
    - Go to the Process Request window and select the
      record with "Costing Background process" in the Process
      field. Press the Unschedule Process button and then
      Close button in the popup window.

    - Create a new Process Request in this same window,
      with "F&B International Group" as client and "*" Organization.
      Set the Process to "Costing Background process" and Timing
      "Run Immediately". Save the record.
    - Go to the Goods Receipt window and create a new record
      with "Bebidas Alegres, S.L." as Business Partner.
      Go to the Lines Tab and create a new line with "Cerveza Ale 0,5L"
      as Product. Save the record.
      Press the Complete button and OK in the popup window.

    - Go to the Process Request window, select the previously created
      Process request and press the Schedule Process button and then
      Close button in the popup window.

    - Go to the Landed Cost Type window and create a new record. Name it
      TEST. Put "Distribution by Amount" in the Landed Cost Distribution
      Algorithm field and "Capital Social" in the Account field.
      Save the record.

    - Go to the Landed Cost window and create a new record. Leave every
      field as default.
      Go to the Cost Tab and create a new Cost record. Set the previously
      created Landed Cost Type in its field and any desired amount. Make sure
      that the Landed Cost Distribution Algorithm is "Distribution by Amount".
      Go to the Receipt Tab and create a new Receipt record. Set the previously
      created Goods Receipt in th Goods Receipt field, and select the
      "Cerveza Ale 0,5L" line in the Goods Receipt Line.
      Save the record.
      Press the Process button and Done in the popup window.
    #In this moment the modified HQLs are executed#
hgbot (developer)
2020-02-07 14:21

Repository: erp/devel/pi
Changeset: 321d0d9d12bede798b8abbd50e9ffd3668a80aa8
Author: IƱigo Lerga <inigo.lerga <at>>
Date: Tue Feb 04 11:00:33 2020 +0100
URL: [^]

fixes BUG-43107:Applied new HQL Style + finals added

M src/org/openbravo/costing/
hgbot (developer)
2020-02-07 14:21

Repository: erp/devel/pi
Changeset: 8705bc9c753471243ada3365542b5eb99b1b3b13
Author: David Miguelez <david.miguelez <at>>
Date: Fri Feb 07 14:20:15 2020 +0100
URL: [^]

Related to ISSUE-43107: Code Review changes
* Use ids instead of objects in hql query
* Changed names of variables to better reflect
that they refer to ids

M src/org/openbravo/costing/
dmiguelez (developer)
2020-02-07 14:21

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2020-02-04 10:06 inigo_lerga New Issue
2020-02-04 10:06 inigo_lerga Assigned To => inigo_lerga
2020-02-04 10:06 inigo_lerga Modules => Core
2020-02-04 10:06 inigo_lerga Triggers an Emergency Pack => No
2020-02-04 10:06 inigo_lerga Relationship added related to 0041287
2020-02-04 10:07 inigo_lerga Status new => scheduled
2020-02-04 10:59 inigo_lerga Note Added: 0117450
2020-02-07 14:21 hgbot Checkin
2020-02-07 14:21 hgbot Note Added: 0117574
2020-02-07 14:21 hgbot Status scheduled => resolved
2020-02-07 14:21 hgbot Resolution open => fixed
2020-02-07 14:21 hgbot Fixed in SCM revision => [^]
2020-02-07 14:21 hgbot Checkin
2020-02-07 14:21 hgbot Note Added: 0117575
2020-02-07 14:21 dmiguelez Review Assigned To => dmiguelez
2020-02-07 14:21 dmiguelez Note Added: 0117576
2020-02-07 14:21 dmiguelez Status resolved => closed
2020-02-07 14:21 dmiguelez Fixed in Version => 3.0PR20Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker