0017913: Navigation to blank tab

Description

Direct navigation to related objects results in a blank page in some occasions.

This can happen when the number of records in the destiny table is big enough and the default sorting column for that tab does not do a deterministic order.

When doing the navigation, it is not only loaded the selected record but a set of records that must contain the selected one. This is done to be able to switch to grid view quickly. In order to do it 2 queries are executed to DB: 1st one to determine the position of the selected record and 2nd one to get the actual data limiting the results to a number (100) of records that includes the selected one.

In the case described above, it can happen 2nd query doesn't order in the same way 1st one does. If this happens and the 2nd query does not include selected record, tab is shown blank.

Workaround: when this happens it can be easily solved by using a sort column (Record Sort No. in tab) one which is unique (i.e. document no) so it makes the order deterministic.

Steps To Reproduce

Can be reproduced in ob@ob3 navigating from SO 10000528 to its contract

Proposed Solution

Always append record id to the order by clause

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0017925

3.0MP2

closed

alostale

Navigation to blank tab having inactive records

Notes
(0038893) hgbot (developer) 2011-07-06 11:04	Repository: erp/devel/pi Changeset: 02f28176ed17911766685cdcbfef6e57d4e35e32 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Wed Jul 06 10:51:48 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/02f28176ed17911766685cdcbfef6e57d4e35e32 [^] fixed bug 17913: Navigation to blank tab --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/DefaultJsonDataService.java ---

(0038909) hudsonbot (developer) 2011-07-06 20: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/7aa2bbafa595 [^] Maturity status: Test

(0039032) maite (developer) 2011-07-13 10:52	verified

Issue History
Date Modified	Username	Field	Change
2011-07-06 10:02	alostale	New Issue
2011-07-06 10:02	alostale	Assigned To	=> alostale
2011-07-06 10:02	alostale	Modules	=> JSON Datasource
2011-07-06 10:31	alostale	Description Updated	View Revisions
2011-07-06 10:31	alostale	Proposed Solution updated
2011-07-06 11:04	hgbot	Checkin
2011-07-06 11:04	hgbot	Note Added: 0038893
2011-07-06 11:04	hgbot	Status	new => resolved
2011-07-06 11:04	hgbot	Resolution	open => fixed
2011-07-06 11:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/02f28176ed17911766685cdcbfef6e57d4e35e32 [^]
2011-07-06 20:41	hudsonbot	Checkin
2011-07-06 20:41	hudsonbot	Note Added: 0038909
2011-07-07 07:56	alostale	Relationship added	related to 0017925
2011-07-13 10:52	maite	Note Added: 0039032
2011-07-13 10:52	maite	Status	resolved => closed