Oracle Fusion Cloud - Search records action

The Search records batch action finds records by specific attribute values.

Input

Input fieldDescription
ObjectSelect the object type to search for.
Search operationSelect the operator for combined expressions. Options include And and OR. And returns records matching all specified attributes. Or returns records matching at least one specified attribute.
LimitSpecify the number of resources to return. The minimum is 1, and the maximum is 500. Defaults to 100.
OffsetDefine the starting position of the resource collection. Default value is 0.
ExpandSelect the child and grandchild objects to include in the output.
Order byThis parameter orders a resource collection based on the specified attributes. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and asc or desc. Specify asc for ascending and desc for descending. The default value is asc. e.g. field1:asc,field2:desc
Search byExpand this field to specify how you plan to search for a record.

Output

Returns a list of records that match the search criteria, including record details, the total number of matches, limit and offset values, and an indicator showing whether more records are available in a separate job.

Last updated: