Configuring Default Filtering and Sorting

Configure default filter and sort expressions wherever a REST Data Source type supports them.

For example, the Oracle Cloud Applications, ORDS, and OData REST Data Source types all support their own declarative filter and order by syntax. By enabling the External Filter and Order By switch on a region or List of Value, you can specify either or both using an appropriately structured clause.

For example, imagine working with a REST API from the Fusion Applications Customer Experience pillar. In a region using a REST Data Source based on the Sales Opportunities business object endpoint, you might want to only show open opportunities with a win probability greater than 75%. To achieve this, you can specify the following External Filter clause on the region:

StatusCode = 'OPEN' and WinProb >= 75

Then, say you want those results ordered descending by win probability and then by the primary contact. To make that happen, just specify the External Order By clause of:

WinProb:desc,PrimaryContactPartyName:asc

For more information on external filter and order by syntax for Fusion Applications REST APIs, see REST Data Source Runtime Features for Oracle Cloud SaaS Apps and BOSS REST Data Source Runtime Features in Oracle APEX App Builder User’s Guide.

When configuring the same features for ORDS or OData REST Data Source, check with the documentation of those services to understand the filtering and sorting syntax they expect.