Project: 	
  | View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0022734 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] A. Platform | major | have not tried | 2013-01-08 11:08 | 2013-01-09 05:41 | |||
| Reporter | AugustoMauch | View Status | public | |||||
| Assigned To | AugustoMauch | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 9ad8f68a0a90 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP19 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | shankarb | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0022734: Add the functionality to define a widget that feeds from a user-defined datasource | |||||||
| Description | The Query Widget functionality needs to be extended so a widget can be associated with a datasource and feed its data from it. | |||||||
| Steps To Reproduce | The 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  | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
		  Relationships		[ Relation Graph ] 
		[ Dependency Graph ] 
			 | 
|||||||||||||||
  | 
|||||||||||||||
  		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 (viewer) 2013-01-08 18:46  | 
	Code Reviewed and tested in changeset be593a18eebe | 
| 
				(0055394) hudsonbot (viewer) 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 (viewer) 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 | OBNetwork customer | => No | 
| 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 |