The OBiEE XmlViewService Web Service Method Does Not Handle Fetch Previous Records
Last updated on MARCH 21, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.161018 and later
Information in this document applies to any platform.
The XMLViewService Service handles the following functions:
For both, executeSQLQuery() Method and executeXMLQuery() Method, the documentation states:
If the results returned exceed one page, you need to use the fetchNext() Method to return the next page of rows.
There is no method available to handle the previous page request.
When a user is presented with a list of records, the length of the list is determined by the page set size (maxRowsPerPage parameter)
In many cases, this number is greater than the number of records displayed on the first page, so the user must click on the UI element resulting in the fetchNext() request being submitted. The fetchNext() returns the next page of data.
The XMLViewService Service does not handle the request for the previous page.
The business user does notknow what the second page contains until he has viewed that data (or the third etc.). Once one has viewed that non-first-page data set, one may decide that one wants to view the last set of data he just looked at, without:
- starting over again from the beginning of the request process which resulted in the first page being loaded
- remembering how many pages he had navigated to before getting to the state where one had his desired data displayed and clicking next until one is there again (and hoping one does not hit one too many times requiring another repeat of this cycle).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms