Retrieve User Defined Classifier Query By Object Attributes
    • 25 Sep 2024
    • 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