Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015032Openbravo ERP00. Application dictionarypublic2010-10-26 10:362010-12-30 13:13
Reporteregoitz 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP22 
Target Version3.0RC4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015032: On the dataset definition it is possible to add a table defined from a view
DescriptionOn the dataset definition it is possible to add a table defined from a view.
This is a problem because the data is exported but couldn't be imported because there are views where you can not execute an insert.
Steps To Reproduce-Define a new module and check it as indevelopment
-Go to Application dictionary>dataset
-Select the Client Definition dataset
-Go to tables tab.
-Create a new entrie.
-See that in the tables combo you can select views. for example ad_audit_trail_v
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00154162.50MP25 closed alostale On the dataset definition it is possible to add a table defined from a view 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-10-26 10:36egoitzNew Issue
2010-10-26 10:36egoitzAssigned To => alostale
2010-10-26 10:36egoitzOBNetwork customer => Yes
2010-11-02 07:57alostaleStatusnew => scheduled
2010-12-14 10:41alostaleStatusscheduled => acknowledged
2010-12-14 10:41alostaleTarget Version2.50MP25 => 3.0RC4
2010-12-14 10:41alostaleStatusacknowledged => scheduled
2010-12-14 10:41alostalefix_in_branch => pi
2010-12-14 10:43hgbotCheckin
2010-12-14 10:43hgbotNote Added: 0033149
2010-12-14 10:43hgbotStatusscheduled => resolved
2010-12-14 10:43hgbotResolutionopen => fixed
2010-12-14 10:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/79d70b18309ee4006d1cb72245405e14448cee8a [^]
2010-12-14 11:56marvintmNote Added: 0033158
2010-12-14 11:56marvintmStatusresolved => closed
2010-12-16 22:16anonymoussf_bug_id0 => 3138788
2010-12-30 13:13hudsonbotCheckin
2010-12-30 13:13hudsonbotNote Added: 0033440

Notes
(0033149)
hgbot   
2010-12-14 10:43   
Repository: erp/devel/pi
Changeset: 79d70b18309ee4006d1cb72245405e14448cee8a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Dec 14 10:43:05 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/79d70b18309ee4006d1cb72245405e14448cee8a [^]

fixed bug 15032: On the dataset definition it is possible to add a table defined from a view

---
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0033158)
marvintm   
2010-12-14 11:56   
Verified that you cannot add views to a dataset anymore.
(0033440)
hudsonbot   
2010-12-30 13:13   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/79d70b18309e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7d7e5eebcc62 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19448.obx [^]