Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0022083
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 00. Application dictionaryminorN/A2012-10-24 10:182012-11-02 13:46
ReportermiruritaView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in Version3.0MP17
StatusclosedFix in branchFixed in SCM revisionb1a3f1b424e0
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022083: Computed columns should work also with non primitive references (table, tabledir, search, OBUISEL_Selector Reference...)

DescriptionComputed columns should work also with non primitive references (table, tabledir, search, OBUISEL_Selector Reference...)
Steps To Reproduce1) Create a new column on c_invoice table
 - Column name: TestComputedColumn
 - SQLLogic:
(select max(il.c_invoiceline_id) from c_invoiceline il where il.c_invoice_id = c_invoice_id)
 - Reference: Table
 - Reference Search Key: Project Selector

2) Create corresponding field for previous column on Sales Invoice >> Header tab.

3) Compile a go to this window.

You will get an error: Could not execute query
it is trying to select c_invoice.TestComputedColumn column in database when it does not exist.
Proposed SolutionIt is possible to use the formula property also for many-to-one references in the hibernate mapping file.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0053667)
hgbot (developer)
2012-10-24 22:54

 Repository: erp/devel/pi
Changeset: ca38f3f7ec3b9f485182fb5350bbf099b50757c5
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Oct 24 22:53:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ca38f3f7ec3b9f485182fb5350bbf099b50757c5 [^]

Fixes issue 22083: Computed columns should work also with non primitive references
Property formula is also supported for many-to-one

---
M src/org/openbravo/dal/core/DalMappingGenerator.java
---
(0053711)
hudsonbot (viewer)
2012-10-25 12:39

 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/4a27e27689bc [^]

Maturity status: Test
(0053826)
AugustoMauch (administrator)
2012-10-30 14:33

 The compilation fails after creating the column and the field the way it is described in the steps to reproduce.
(0053844)
hgbot (developer)
2012-10-30 17:29

 Repository: erp/devel/pi
Changeset: b1a3f1b424e0a6cc755b358dddd0fd1278ce41ad
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Oct 30 17:28:35 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b1a3f1b424e0a6cc755b358dddd0fd1278ce41ad [^]

Fixes issue 22083: Computed columns should work also with non primitive references
Prevent a virtual/list property for properties which have sql logic

---
M src/org/openbravo/base/model/ModelProvider.java
---
(0053943)
hudsonbot (viewer)
2012-10-31 13:31

 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/9e773cbcb723 [^]

Maturity status: Test
(0053983)
AugustoMauch (administrator)
2012-11-02 13:46

 Code reviewed and verified in pi@37da9a5ba373

- Issue History
Date Modified Username Field Change
2012-10-24 10:18 mirurita New Issue
2012-10-24 10:18 mirurita Assigned To => mtaal
2012-10-24 10:18 mirurita Modules => Core
2012-10-24 10:18 mirurita OBNetwork customer => No
2012-10-24 22:46 mtaal Review Assigned To => AugustoMauch
2012-10-24 22:46 mtaal Proposed Solution updated
2012-10-24 22:54 hgbot Checkin
2012-10-24 22:54 hgbot Note Added: 0053667
2012-10-24 22:54 hgbot Status new => resolved
2012-10-24 22:54 hgbot Resolution open => fixed
2012-10-24 22:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ca38f3f7ec3b9f485182fb5350bbf099b50757c5 [^]
2012-10-25 12:39 hudsonbot Checkin
2012-10-25 12:39 hudsonbot Note Added: 0053711
2012-10-30 14:33 AugustoMauch Note Added: 0053826
2012-10-30 14:33 AugustoMauch Status resolved => new
2012-10-30 14:33 AugustoMauch Resolution fixed => open
2012-10-30 17:29 hgbot Checkin
2012-10-30 17:29 hgbot Note Added: 0053844
2012-10-30 17:29 hgbot Status new => resolved
2012-10-30 17:29 hgbot Resolution open => fixed
2012-10-30 17:29 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/ca38f3f7ec3b9f485182fb5350bbf099b50757c5 [^] => http://code.openbravo.com/erp/devel/pi/rev/b1a3f1b424e0a6cc755b358dddd0fd1278ce41ad [^]
2012-10-31 13:31 hudsonbot Checkin
2012-10-31 13:31 hudsonbot Note Added: 0053943
2012-11-02 13:46 AugustoMauch Note Added: 0053983
2012-11-02 13:46 AugustoMauch Status resolved => closed
2012-11-02 13:46 AugustoMauch Fixed in Version => 3.0MP17

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker