lastRow and nextPage , how to jump to the lastRow in UI

Hi Uwe,

As you have mentioned, these two APIs are currently missing but we are planning to implement them for the version 1.2.3 .

In the meantime, you can use the following procedure to navigate to the last page of a datasource:

-- @param in_datasourceName_tx Name of the datasource
-- @param in_fetchMode_cd      Fetch mode of the datasource
procedure lastPage(in_datasourceName_tx varchar2, in_fetchMode_cd varchar2 := 'FetchAll') is
  v_lastPage_nr number;
  v_rowCount_nr number;
begin
  if in_fetchMode_cd = 'FetchAll' then
    v_rowCount_nr := api_datasource.getRowCount(in_datasourceName_tx);
  elsif in_fetchMode_cd = 'Paging' then
    v_rowCount_nr := api_datasource.getCompleteRowCount(in_datasourceName_tx);
  end if;
  v_lastPage_nr :=  ceil(v_rowCount_nr / api_datasource.getrowsperpage(in_datasourcename_tx));
  api_datasource.setpage(in_datasourceName_tx, v_lastPage_nr);
end;

If the rowsPerPage values of your datasources are not changing during runtime, you can define package constants holding the rowsPerPage values of your datasources to avoid the api_datasource.getRowsPerPage API call.

Also, please note that the api_datasource.setPage API sets the first row of the navigated page as the current row of the datasource. Therefore, you have to make the api_datasource.lastRow API call after this custom lastPage procedure.

Navigating to the first page is easier:

procedure firstPage(in_datasourceName_tx varchar2) is
begin
  api_datasource.setpage(in_datasourceName_tx, 1);
end;

Hope this helps,
Ibrahim