How To Implement Filtering For Service Data Provider Involving Parent-Child Relations? (Doc ID 2948440.1)

Last updated on MAY 18, 2023

Applies to:

Goal

A Visual Builder application has a page with an component based upon a Service Data Provider (SDP).

The SDP is backed by two Business Objects, let's call them A and B, one is the parent (i.e. A) and the other is the child (i.e. B).

Sorting works only on A's columns, but not on B's columns.

Filter criterion at REST endpoint side and transform functions have already been set, but that has not been enough to let the sorting on B's column work.

How to implement the above use-case?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.