I'm having an issue with items disappearing after sorting. For example, there is a list of 9 items with the same date, after I sort the date column, I navigate to the page with that date range, I only see 8 of those items. However if I export the whole list to Excel, I see all 9 items in the right order.
Not that I know of. I already tried going to the database backend directly using an Oracle Client (Toad) to see the database directly, I don't notice anything unusual about that.
Another thing I notice is, because the portlet has multiple pages, if I flip through the pages back and forth the item occasionally appears. However if I sort by request number it appears always. And again it always appear in the Excel export.
What information specifically do you need to know about the portlet? The portlet only filters by one text field.
Is this list being generated with a portlet? Are there more entries in the database that meet the search criteria than are allowed for a portlet? The limit is configured in server.conf and OOTB is set to 200. Oracle seems to behave somewhat randomly on which rows are returned when the maximum number of rows is exceeded.