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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0022734
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajorhave not tried2013-01-08 11:082013-01-09 05:41
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision9ad8f68a0a90
ProjectionnoneETAnoneTarget Version3.0MP19
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toshankarb
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022734: Add the functionality to define a widget that feeds from a user-defined datasource

DescriptionThe Query Widget functionality needs to be extended so a widget can be associated with a datasource and feed its data from it.
Steps To ReproduceThe steps to create this new widget would be:
- Create a new Datasource in Java, and define it in the application dictionary
- Create a new Query Widget
- In the Query tab, set its type to Datasource, and associate the widget with the previosly defined datasource
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00227353.0MP19 closedAugustoMauch Incorrect length in column OBCQL_WIDGET_QUERY.TYPE 
related to defect 0022949 closedAugustoMauch Export database: wrong index name 

-  Notes
(0055372)
hgbot (developer)
2013-01-08 11:42

Repository: erp/devel/pi
Changeset: 9ad8f68a0a90e6a64f559da28b3775d6c16f33c7
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Jan 08 11:39:12 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9ad8f68a0a90e6a64f559da28b3775d6c16f33c7 [^]

Fixes issue 22734: New functionality: widgets with user-defined datasource

Summary of the changes:
- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_COLUMN.xml: The HQL column has been changed in the application dictionary so it is no longer mandatory
- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_REFERENCE.xml: New list reference that holds the possible query widget types
- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_REF_LIST.xml: List items of the new reference ('DS' and 'HQL').
- modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml: Database changes in the OBCQL_WIDGET_QUERY table:
            * The HQL column is no longer mandatory
            * Added two new columns: Type and Datasource
- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_COLUMN.xml: Definition of the new columns in the Column table of the application dictio
nary
- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_FIELD.xml: Definition of the new columns in the Field table of the application dictiona
ry, plus a change in the display logic of the HQL field so that it is only shown when the proper option is selected in the Type field.
- modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListWidgetProvider.java: Logic that uses the user-defined datasource when fet
ching the data of a widget that is associated with a user-defined datasource.

---
M modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_REFERENCE.xml
M modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
M modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListWidgetProvider.java
A modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_REF_LIST.xml
---
(0055378)
hgbot (developer)
2013-01-08 13:47

Repository: erp/devel/pi
Changeset: dbcffe4c26976552f55fad3ddab4350acded65d9
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Jan 08 13:46:11 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dbcffe4c26976552f55fad3ddab4350acded65d9 [^]

Related to issue 22734: HQL field is no longer mandatory

Now a Query widget can be defined either with a HQL query or with a datasource, so the HQL query is no longer mandatory.

---
M modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_COLUMN.xml
---
(0055390)
shankarb (reporter)
2013-01-08 18:46

Code Reviewed and tested in changeset be593a18eebe
(0055394)
hudsonbot (developer)
2013-01-09 05:41

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/195064f93651 [^]

Maturity status: Test
(0055398)
hudsonbot (developer)
2013-01-09 05:41

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/195064f93651 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-01-08 11:08 AugustoMauch New Issue
2013-01-08 11:08 AugustoMauch Assigned To => AugustoMauch
2013-01-08 11:08 AugustoMauch Modules => Core
2013-01-08 11:08 AugustoMauch Triggers an Emergency Pack => No
2013-01-08 11:41 AugustoMauch Review Assigned To => shankarb
2013-01-08 11:41 AugustoMauch Issue Monitored: shankarb
2013-01-08 11:42 hgbot Checkin
2013-01-08 11:42 hgbot Note Added: 0055372
2013-01-08 11:42 hgbot Status new => resolved
2013-01-08 11:42 hgbot Resolution open => fixed
2013-01-08 11:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9ad8f68a0a90e6a64f559da28b3775d6c16f33c7 [^]
2013-01-08 12:48 AugustoMauch Relationship added related to 0022735
2013-01-08 13:47 hgbot Checkin
2013-01-08 13:47 hgbot Note Added: 0055378
2013-01-08 18:46 shankarb Note Added: 0055390
2013-01-08 18:46 shankarb Status resolved => closed
2013-01-08 18:46 shankarb Fixed in Version => pi
2013-01-09 05:41 hudsonbot Checkin
2013-01-09 05:41 hudsonbot Note Added: 0055394
2013-01-09 05:41 hudsonbot Checkin
2013-01-09 05:41 hudsonbot Note Added: 0055398
2013-01-31 17:16 AugustoMauch Relationship added related to 0022949


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker