Hi,
I am facing an issue when trying to sort the column in the VBCS table component (<oj-table>) using the header button.
The issue is that the table does not display all the results after sorting a column that has NULL values.
Steps to Replicate:
- Table Result with more than 500 Rows.
- Use Business Object and SDP to fetch data.
- Sort any column having null values using the column header button (^ v).
- It will display only a few records (<50) and is unable to scroll further.
My Observation:
- In the Browser network, I am seeing all 500 records getting fetched.
- In UI, I am seeing only a few records and a blank space at the end of the scroll.
- I am seeing this behavior all over the application wherever I am using table sorting.
Please let me know if you have any solution to this issue.
Code Snippet for Reference.
<oj-table class="oj-flex-item oj-sm-12 oj-md-12 oj-table-stretch" columns='[{"headerText":"Field Name","field":"expressContract","template":"multiFieldCellTemplate1","resizable":"enabled"},{"headerText":"Field Name","field":"FN","id":"ff4","resizable":"enabled","sortable":"enabled"},{"headerText":"FN2","field":"FN1","id":"ff5","resizable":"enabled","sortable":"enabled"},{"headerText":"FN3","field":"fn4","resizable":"enabled","sortable":"enabled"},{"headerText":"FG1","field":"ff1","resizable":"enabled","sortable":"enabled"},{"headerText":"ffe2","field":"ffr3","resizable":"enabled","sortable":"enabled"},{"headerText":"ff4","field":"ff4","resizable":"enabled","sortable":"enabled"},{"headerText":"ff5","field":"ff4","resizable":"enabled","sortable":"enabled"},{"headerText":"ff3","field":"de22","sortable":"enabled","template":"multiFieldCellTemplate5","resizable":"enabled"},{"headerText":"ff6","field":"dd3","template":"multiFieldCellTemplate6","resizable":"enabled","sortable":"enabled"}]' style="height: 500px;width:100%;border:thin-solid;" selection-mode.row="single" selection-mode.column="single" horizontal-grid-visible="enabled" vertical-grid-visible="disabled" on-first-selected-row-changed="[[$listeners.tableFirstSelectedRow]]" dnd.reorder.columns="enabled" id="searchtbl" data="[[ $application.variables.SearchVwListFlowSDP ]]" scroll-policy="loadMoreOnScroll"> <template slot="multiFieldCellTemplate1"> <a target="_blank" on-click="[[$listeners.hyperlinkClick]]"> <oj-bind-text value="[[ $current.row.ff1]]"></oj-bind-text> </a> </template> <template slot="multiFieldCellTemplate5"> <oj-input-date value="[[ $current.row.ff3]]" readonly="true" converter='{"type": "datetime", "options": {"pattern":"MM/dd/yyyy","isoStrFormat": "offset","timeZone":"GMT"}}'> </oj-input-date> </template> <template slot="multiFieldCellTemplate6"> <oj-input-date value="[[ $current.row.ff5]]" readonly="true" converter='{"type": "datetime", "options": {"pattern":"MM/dd/yyyy","isoStrFormat": "offset","timeZone":"GMT"}}'> </oj-input-date> </template> </oj-table>