Is it possible to use BDP in row-expander?
Summary:
Implementing Row Expander Table with Load More on Scroll in ORDS API
Content (please ensure you mask any confidential information):
Hi Team,
I am working on implementing a row expander table with a "load more on scroll" feature using an ORDS API. The API already provides the data in the desired parent-child structure, and it works as expected when using an any type variable. However, the "load more on scroll" functionality is not working due to the use of the any type.
To address this, I am considering using a BDP tied to an SDP to enable the "load more on scroll" functionality. Is it possible to convert the BDP into a flattened tree structure to achieve this functionality? The API returns over 2,000 records, so performance and scalability are key considerations.