Skip to Main Content

Visual Builder

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sorting of column in VBCS table is not fetching all the rows if the columns has Null values (Column Header Sorting)

Pavan Kumar T NJun 16 2023 — edited Jun 16 2023

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.

VBCS version 23.04.3

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.

This post has been answered by Pavan Kumar T N on Jun 23 2023
Jump to Answer
Comments