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.
| Parameter | Description | Sample |
|---|---|---|
| CreateDateVar | Create Date | 2020-10-20 |
| UdfCodeVar | UDF Code | RTYPE |
| ActualValueVar | Actual Value | Type2 |
| ObjectTypeVar | Object Type | DMISSUE |
Select by Primary Key
This is the optional finder for querying a unique User Defined Classifier by primary key (combination of keys).
| Parameter | Description | Sample |
|---|---|---|
| OmcvObjectKey1 | ObjectKey 1 | 001 |
| OmcvObjectKey2 | ObjectKey 2 | 180831 |
| OmcvObjectKey3 | ObjectKey 3 | IS00001 |
| OmcvObjectKey4 | ObjectKey 4 | null |
| OmcvObjectType | Object Type | DMISSUE |
| OmcvUdfCode | UDF Code | RTYPE |
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