When I search for a table item that is not listed in the current number of rows available (I’ll call that a page), the table displays nothing until I shift “pages” to display the row that contains the data.
Is there a setting that will make the table automatically shift to display the data without moving through “pages” of rows?
I should add that I’m not using the regular query-building filter. I’m using SQL calls to the database and then refreshing the table and data source like this:
There’s also a problem with sorting. When I use the built-in sorting feature at the top of the table, not all data is sorted, just the data on the current “page” of rows. This doesn’t always happen, but here and there a record or two doesn’t get sorted correctly if I proceed to a following “page” of rows.
If the table contents does not fit in one page, the datasource issues a new select to the database with appropriate order by clause. Could you monitor app.log and find out if the select statement is correct after you apply a new sort order? In order to see SQL statements, switch the eclipselink.sql logger to DEBUG.
In the normal situation paging is always adjusted to the number of rows actually present in the table. See screenshots attached. So, in order to help you, we need additional information.
We create a custom search,and when not on the first page, for example, when we query on the last page, the data we query is not displayed on the page and must be manually skipped to the first page.
The query results are automatically displayed on the first page, as are the custom queries, as well as the framework’s own queries.
Thanks!
i have the exact same issue. is there a solution for it ? I mean for the following issue:
User opens the browse window
navigates to the for example third page
User uses a filter (browse controller changes the sql of the datasource .setquery() and calls a .refresh())
the remaining say 4 records the modified query gives back are shown on the first page, but the table is still on the third page.
the user has to navigate two pages back, in order to see any data.
how can we solve this issue? is there any reload function for the table itself ? i mean after the query got changed and the .refresh() on the datasource got called, there are for example only 4 records. so a paging then wouldn’t make any sense, becaue we only have 4 records left (with the new query).
would be great if someone has solved this issue or at least knows a workaround for this,