ADFBC SDO FindCriteria Operators

Searching for data using the ADC BC SDO api is well documented, but very unintuitive to use. Official documentation is very sparse in good examples of using the api for simple use cases. Recently, We had to write a simple query where a column was being checked for null value. Sounds like a very simple use case to code for. So, something like the following was required:

“where doctorsOrders is null”

Translate this to a ViewCriteriaItem in SDO Finders goes something like this

There is this obsure class called JboCompOper that offers all these constants and can be found at the reference below.
ADF BC JboCompOper Constants

vivek

Oracle Fusion Middleware Architect at FUSION Applied
Vivek is an Oracle Certified Fusion Middleware architect. He has over 18 years of experience implementing custom software solutions in the Financial, Health, and Government sectors. He is one of the founders of Fusion Applied.
vivek

Leave a Reply

avatar
  Subscribe  
Notify of