Retrieve User Defined Classifier Query By Object Attributes
  • 27 Feb 2025
  • 1 Minute to read
  • Dark
    Light

Retrieve User Defined Classifier Query By Object Attributes

  • Dark
    Light

Article summary

Get
/sys-rest-api/rest/1/userdefinedclassifierquery

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

  • Select by UDC Query Finder
  • Select by Primary Key

Select by UDC Query Finder

Recommended finder parameters. Refer to Query Parameters for example.

ParameterDescriptionSample
CreateDateVarCreate Date2020-10-20
UdfCodeVarUDF CodeRTYPE
ActualValueVarActual ValueType2
ObjectTypeVarObject TypeDMISSUE

Select by Primary Key

This is the optional finder for querying a unique User Defined Classifier by primary key (combination of keys).

ParameterDescriptionSample
OmcvObjectKey1ObjectKey 1001
OmcvObjectKey2ObjectKey 2180831
OmcvObjectKey3ObjectKey 3IS00001
OmcvObjectKey4ObjectKey 4null
OmcvObjectTypeObject TypeDMISSUE
OmcvUdfCodeUDF CodeRTYPE
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExampleUDCQueryFinder;CreateDateVar=2020-10-20, UdfCodeVar=RTYPE, ActualValueVar=Type2, ObjectTypeVar=DMISSUE
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
ExampleTrue
orderBy
string
ExampleOmcvUdfCode:desc
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
{
  "items": [
    {
      "OmcvActualValue": "Type2",
      "OmcvIuCreateDate": "2020-10-20T12:45:31Z",
      "OmcvIuUpdateDate": "2020-10-20T12:45:43Z",
      "OmcvObjectKey1": "001",
      "OmcvObjectKey2": "180831",
      "OmcvObjectKey3": "IS00001",
      "OmcvObjectKey4": null,
      "OmcvObjectOraseq": 315503414,
      "OmcvObjectType": "DMISSUE",
      "OmcvOraseq": 742015098,
      "OmcvTenantId": "VF389BTEQP11127",
      "OmcvUdfCode": "RTYPE",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/userdefinedclassifierquery/000600000003303031000000063138303833310000000749533030303031FFFFFFFF00000007444D4953535545000000055254595045",
          "name": "userdefinedclassifierquery",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/userdefinedclassifierquery/000600000003303031000000063138303833310000000749533030303031FFFFFFFF00000007444D4953535545000000055254595045",
          "name": "userdefinedclassifierquery",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 25,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/userdefinedclassifierquery",
      "name": "userdefinedclassifierquery",
      "kind": "collection"
    }
  ]
}
object