Skip to main content

work_request_logs

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

Overview​

Namework_request_logs
TypeResource
Idoci.work_requests.work_request_logs

Fields​

The following fields are returned by SELECT queries:

A log message from executing an operation that is tracked by a work request.

NameDatatypeDescription
messagestringA human-readable log message.
timestampstring (date-time)The date and time the log message was written.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectworkRequestId, regionlimit, page, sortOrder, opc-request-idGets 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 work request.
limitintegerFor list pagination. The maximum number of results per page, or items to return in a paginated "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).
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 response header from the previous "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples​

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

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