Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017411Openbravo ERPB. User interfacepublic2011-05-30 09:112012-09-28 14:39
mbernal 
AugustoMauch 
highmajoralways
closedfixed 
20Community Appliance
 
3.0MP173.0MP16 
AugustoMauch
Query/List widget
No
0017411: Links in widgets of type "Query" are not working properly
When defining a Query/List widget, after setting the HQL query it will execute, columns for this widget have to be defined.

When one of these columns has marked the "Has Link" check, and it is properly configured, the widget will provide a link in this column to the selected tab and recordId.

Nowadays, it is not linking to the correct tab, but to the default tab for the table.
1. Create a copy of the window "Purchase Invoice".
2. In the default widget "Invoices to Pay", change the link in "Document Number" to the Header tab on this newly created window.
3. When creating a new instance of this widget, the link will still point to Purchase Invoice.

4. This happens always with any querylist widget, or any window which is not defined as default Window or default PO Window in AD_Table.
No tags attached.
related to feature request 0015379 closed gorkaion Extend navigation model 
related to defect 00187803.0MP5 closed dbaz The window/tab defined on the query/list widget to create the link is not taken into account 
Issue History
2011-05-30 09:11mbernalNew Issue
2011-05-30 09:11mbernalAssigned To => dbaz
2011-05-30 09:11mbernalModules => Query/List widget
2011-05-30 16:34dbazAssigned Todbaz => gorkaion
2011-09-19 23:09psarobeAssigned Togorkaion => iperdomo
2011-09-19 23:09psarobeStatusnew => scheduled
2011-09-22 11:28iperdomoAssigned Toiperdomo => dbaz
2011-10-17 16:30dbazRelationship addedrelated to 0018780
2011-10-17 16:34hgbotCheckin
2011-10-17 16:34hgbotNote Added: 0041857
2011-10-17 16:34hgbotStatusscheduled => resolved
2011-10-17 16:34hgbotResolutionopen => fixed
2011-10-17 16:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f28965132f63fde3ab10af32bc4510ba15085bdf [^]
2011-10-23 13:41hudsonbotCheckin
2011-10-23 13:41hudsonbotNote Added: 0042006
2011-11-03 15:43alostaleNote Added: 0042480
2011-11-03 15:43alostaleStatusresolved => new
2011-11-03 15:43alostaleResolutionfixed => open
2011-11-14 08:40alostaleNote Added: 0042807
2011-11-14 08:40alostaleTypedefect => design defect
2011-11-14 08:48alostaleRelationship addedrelated to 0015379
2011-11-14 08:49alostaleNote Added: 0042808
2011-11-14 08:49alostaleStatusnew => scheduled
2011-11-14 08:49alostalefix_in_branch => pi
2012-09-20 11:54alostaleNote Added: 0052258
2012-09-20 11:54alostaleTypedesign defect => defect
2012-09-20 11:54alostalefix_in_branchpi =>
2012-09-20 11:55alostaleAssigned Todbaz => AugustoMauch
2012-09-20 11:57alostaleTarget Version => 3.0MP17
2012-09-25 16:00vmromanosIssue Monitored: vmromanos
2012-09-26 09:52hgbotCheckin
2012-09-26 09:52hgbotNote Added: 0052603
2012-09-26 09:52hgbotStatusscheduled => resolved
2012-09-26 09:52hgbotResolutionopen => fixed
2012-09-26 09:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f28965132f63fde3ab10af32bc4510ba15085bdf [^] => http://code.openbravo.com/erp/devel/pi/rev/c7a170e05b3f4d9095ae14180070d64af1a3f667 [^]
2012-09-26 09:55AugustoMauchNote Added: 0052604
2012-09-26 09:55AugustoMauchClosed by => AugustoMauch
2012-09-26 09:55AugustoMauchNote Added: 0052605
2012-09-26 09:55AugustoMauchStatusresolved => closed
2012-09-26 09:55AugustoMauchFixed in Version => 3.0MP16
2012-09-28 14:39hudsonbotCheckin
2012-09-28 14:39hudsonbotNote Added: 0052905

Notes
(0041857)
hgbot   
2011-10-17 16:34   
Repository: erp/devel/pi
Changeset: f28965132f63fde3ab10af32bc4510ba15085bdf
Author: David Baz Fayos <david.baz <at> openbravo.com>
Date: Mon Oct 17 16:34:06 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f28965132f63fde3ab10af32bc4510ba15085bdf [^]

Fixed issue 18780 - Fixed issue 17411: Now query list widget links works ok
when no 'Window' nor 'Window PO' defined in the column definition

---
M src/org/openbravo/erpCommon/utility/ReferencedLink.java
---
(0042006)
hudsonbot   
2011-10-23 13: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/35bf0a7aa166 [^]

Maturity status: Test
(0042480)
alostale   
2011-11-03 15:43   
Commited changeset fixes issue 0018780 but not this one.

Now when there is no window/window po in the referenced table, the one defined in the widget is used. But in case the table has window/window po, this one is used regardless what is specified in the widget.
(0042807)
alostale   
2011-11-14 08:40   
This is a design defect.

Currently, link tab is used just to get the entity for the link column. With this entity standard linked items is used to determine which is the actual tab to navigate to.

Using directly the tab in the link wouldn't be enough for the case of tables having different SO/PO windows.
(0042808)
alostale   
2011-11-14 08:49   
Also related to issue 0015379: when extending navigation model this should be also taken into account.
(0052258)
alostale   
2012-09-20 11:54   
Updating to defect.

After discussing it with ICI the conclusion is: it was originally designed to navigate to the tab defined in the widget regardless standard navigation and it was incorrectly implemented.

Note changing this implementation will make widgets displaying in the same list sales and purchases records to work incorrectly, but this is a corner case which solution would be to split the widget in two: one for sales and another one for purchase info.
(0052603)
hgbot   
2012-09-26 09:52   
Repository: erp/devel/pi
Changeset: c7a170e05b3f4d9095ae14180070d64af1a3f667
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu Sep 20 17:54:18 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c7a170e05b3f4d9095ae14180070d64af1a3f667 [^]

Fixes Issue 0017411: Incorrect behaviour of links in query/list widgets.

In query/list widgets, when links are attached the Entity was used as reference to navigate to the record. Now modified it to use the Tab attached irrespective of the Entity.

---
M modules/org.openbravo.client.querylist/web/org.openbravo.client.querylist/js/ob-querylist-widget.js
---
(0052604)
AugustoMauch   
2012-09-26 09:55   
I have reviewed all Openbravo query widgets, and all of them that showed data from a table that contained both sales and purchases had an additional filter to ensure that only sales records or purchases records are listed on each widget.
(0052605)
AugustoMauch   
2012-09-26 09:55   
Code reviewed and verified in pi@c7a170e05b3f
(0052905)
hudsonbot   
2012-09-28 14: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/6d2f8cffd4b1 [^]

Maturity status: Test