Skip to main content

work_request_logs

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

Overview​

Namework_request_logs
TypeResource
Idoci.logging.work_request_logs

Fields​

The following fields are returned by SELECT queries:

A log message from the execution of a work request.

NameDatatypeDescription
messagestringHuman-readable log message.
timestampstring (date-time)The time the log message was written. An RFC3339-formatted date and time string.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectworkRequestId, regionopc-request-id, page, limitReturn a list of logs for a given 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 asynchronous request ID.
limitintegerWhen setting the page limit, specifies the maximum number of unfiltered records that can be fetched from the data store in one request. Filtering happens after the records are retrieved. Subsequent pages might include results that match the query criteria.
opc-request-idstringUnique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
pagestringFor list pagination. The value of the opc-next-page or opc-previous-page response header from the previous "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).

SELECT examples​

Return a list of logs for a given work request.<br />

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