Skip to main content

work_request_logs

Creates, updates, deletes, gets or lists a work_request_logs resource.

Overview​

Namework_request_logs
TypeResource
Idoci.streaming.work_request_logs

Fields​

The following fields are returned by SELECT queries:

The list of work request logs.

NameDatatypeDescription
messagestringA human-readable log message.
timestampstring (date-time)The date and time the log message was written, in the format defined by [RFC 3339](https:​//tools.ietf.org/html/rfc3339).

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectworkRequestId, regionpage, limit, sortOrder, sortBy, opc-request-idLists the logs for a work request.<br />

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
workRequestIdstringThe [OCID](/iaas/Content/General/Concepts/identifiers.htm) of the asynchronous work request.
limitintegerThe maximum number of items to return. The value must be between 1 and 50. The default is 10.
opc-request-idstringThe unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
pagestringThe page at which to start retrieving results.
sortBystringThe field to sort by. Only one sort order may be provided. Default order for timeAccepted is descending.
sortOrderstringThe sort order to use, either 'asc' or 'desc'.

SELECT examples​

Lists the logs for a work request.<br />

SELECT
message,
timestamp
FROM oci.streaming.work_request_logs
WHERE workRequestId = '{{ workRequestId }}' -- required
AND region = '{{ region }}' -- required
AND page = '{{ page }}'
AND limit = '{{ limit }}'
AND sortOrder = '{{ sortOrder }}'
AND sortBy = '{{ sortBy }}'
AND opc-request-id = '{{ opc-request-id }}'
;