Filter Criteria
The filter criteria resource is used to view, create, update, replace, and delete filter criterias associated with the filter criteria group.
Resource Plural Label |
Filter Criteria |
Resource Name |
__ORACO__FilterCriteriaCollection_c |
Get All Filter Criteria
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__FilterCriteriaGrp_c/{id}/child/__ORACO__FilterCriteriaCollection_c
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the filter criteria group. |
Request Query Parameters
Use these finder parameters to query the resource:
Finder Name | Description |
---|---|
Primary Key |
Finds a filter criteria with the specified primary key. Finder Variables:
|
Request Body
There are no elements in the request body for this task.
Response Body
This table summarizes the supported response body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Create a Filter Criterion
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__FilterCriteriaGrp_c/{id}/child/__ORACO__FilterCriteriaCollection_c
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the filter criteria group. |
Request Body
This table summarizes the supported request body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Response Body
This table summarizes the supported response body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Replace a Filter Criterion
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__FilterCriteriaGrp_c/{id}/child/__ORACO__FilterCriteriaCollection_c/{id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the filter criteria group. |
Id |
integer |
The unique identifier of the filter criteria. |
Request Body
This table summarizes the supported request body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Response Body
This table summarizes the supported response body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Get a Filter Criterion
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__FilterCriteriaGrp_c/{id}/child/__ORACO__FilterCriteriaCollection_c/{id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the filter criteria group. |
Id |
integer |
The unique identifier of the filter criteria. |
Request Body
There are no elements in the request body for this task.
Response Body
This table summarizes the supported response body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Update a Filter Criterion
Request: PATCH
URI: /crmRestApi/resources/11.13.18.05/__ORACO__FilterCriteriaGrp_c/{id}/child/__ORACO__FilterCriteriaCollection_c/{id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the filter criteria group. |
Id |
integer |
The unique identifier of the filter criteria. |
Request Body
This table summarizes the request body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Response Body
This table summarizes the supported response body content types:
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Delete a Filter Criterion
Request: DELETE
URI: /crmRestApi/resources/11.13.18.05/__ORACO__FilterCriteriaGrp_c/{id}/child/__ORACO__FilterCriteriaCollection_c/{id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the filter criteria group. |
Id |
integer |
The unique identifier of the filter criteria. |
Request Body
There are no elements in the request body for this task.
Response Body
There are no elements in the response body for this task.
List of Values
This table lists all the list of values of the resource.
LOV Name | Source Attribute in LOV | Target Attribute in Resource |
---|---|---|
ViewAccessor_CurrencyCode |
CurrencyCode |
CurrencyCode |
FK_LOVVA_For___ORACO__Field_c |
Id |
__ORACO__Field_Id_c |
LOVVA_For___ORACO__Field_c |
RecordName |
__ORACO__Field_c |
LOVVA_For___ORACO__Type_c |
LookupCode |
__ORACO__Type_c |
LOVVA_For___ORACO__FilterOperation_c |
LookupCode |
__ORACO__FilterOperation_c |
Resource Attributes
This table lists all the attributes of the resource.
Attribute Name | Attribute Type | Description |
---|---|---|
Id |
number |
The unique identifier of the filter criterion. UI Label: Record ID |
RecordName |
string |
The name of the filter criterion. Properties: The maximum length is 80. UI Label: Criteria Name |
CreatedBy |
string |
The user who created the filter criterion. Properties: The maximum length is 32. UI Label: Created By |
CreationDate |
datetime |
The date when the filter criterion was created. UI Label: Creation Date |
LastUpdatedBy |
string |
The user who last updated the filter criterion. Properties: The maximum length is 32. UI Label: Last Updated By |
LastUpdateDate |
datetime |
The date when the filter criterion was last updated. UI Label: Last Update Date |
RecordNumber |
string |
The alternate key identifier of the filter criterion. Properties: The maximum length is 64. UI Label: Record Number |
__ORACO__FilterCriteriaGrp_Id_c |
number |
The unique identifier of filter criteria group. |
LastUpdateLogin |
string |
The login of the user who last updated the filter criterion. Properties: The maximum length is 32. |
UserLastUpdateDate |
datetime |
The date and time of the last user update made from a personal device. This value is different from LAST_UPDATE_DATE if the record was originally updated in a different database (i.e. a different mobile database or the server). |
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. Properties: The maximum length is 15. UI Label: Currency Code |
CurcyConvRateType |
string |
The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. Properties: The maximum length is 15. |
CorpCurrencyCode |
string |
The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. Properties: The maximum length is 15. |
__ORACO__Field_Id_c |
number |
The unique identifier of the field for which the criterion is created. UI Label: Field |
__ORACO__Field_c |
string |
The name of the field for which the criterion is created. Properties: The maximum length is 1500. UI Label: Field |
__ORACO__Type_c |
string |
The type of the field. Properties: The maximum length is 1500. UI Label: Type |
__ORACO__FilterOperation_c |
string |
Filter Operation that need to be performed Properties: The maximum length is 1500. UI Label: Filter Operation |
__ORACO__Value_c |
string |
The value of the filter criteria target. Properties: The maximum length is 1500. UI Label: Value |
__ORACO__EndValue_c |
string |
The end value of the filter criteria target. Properties: The maximum length is 1500. UI Label: Value |