Monday, December 26, 2016

ADF REST Framework Version 2 (and later) - 12.2.1.2

While building our new Oracle Cloud application with ADF BC REST and JET, I have discovered not announced feature in ADF BC REST 12.2.1.2. Starting from 12.2.1.2 ADF BC REST offers runtime versions. This is configurable in adf-config.xml file or could be provided through REST request header. ADF 12.2.1.2 supports version 1, 2 and 3. Version 2 offers better query support, while version 3 provides better response for hierarchical data - 16.5.2 What You May Need to Know About Versioning the ADF REST Framework.

You can specify version in adf-config.xml, as per documentation:


Version 2 offers more advanced support for data query. Besides query by example from version 1, we could use advanced query syntax - 22.5.4 Filtering a Resource Collection with a Query Parameter. For example, like operator wasn't supported in version 1:


It is supported in version 2. I could specify version 2 directly in REST request header as in example below:


Download ADF BC REST sample from GitHub repository - jetcrud.

1 comment:

Subramanian Meyyappan said...

Hi Andrejus,

Just am trying to use the following query string for case insensitive search in Oracle JET using ADF BC REST services.

Example:
/Departments?q=UPPER(DeptName) LIKE UPPER('%e%')

Request :
UPPER(NameEn) LIKE UPPER('%Q%');

Response:
The query parameter was provided but it could not be processed. Query: UPPER(NameEn) LIKE UPPER(%Q%);

Ref: https://docs.oracle.com/middleware/12213/adf/develop/consuming-adf-restful-web-services.htm#ADFFD54082

Help me out here.

Regards,
Subramanian