Skip to main content

params_for_action_type

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

Overview​

Nameparams_for_action_type
TypeResource
Idoci.database.params_for_action_type

Fields​

The following fields are returned by SELECT queries:

The Action parameters and their possible values.

NameDatatypeDescription
defaultValuestringThe default value for this parameter.
isRequiredbooleanWhether this parameter is required or not for this action type.、
parameterNamestringThe name of this parameter.
parameterTypestringThe type of the parameter. (BOOLEAN, STRING, INTEGER) (default: STRING)
parameterValuesarrayPossible values for this parameter. In case of integer it's min and max values.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselecttype, regionplanIntent, limit, page, opc-request-idList all the action params and their possible values for a given action type<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)
typestringThe type of the scheduled action
limitintegerThe maximum number of items to return per page.
opc-request-idstringUnique identifier for the request.
pagestringThe pagination token to continue listing from.
planIntentstringThe plan intent the action will be used for. Relevant to action type that can be used in multiple plans

SELECT examples​

List all the action params and their possible values for a given action type<br />

SELECT
defaultValue,
isRequired,
parameterName,
parameterType,
parameterValues
FROM oci.database.params_for_action_type
WHERE type = '{{ type }}' -- required
AND region = '{{ region }}' -- required
AND planIntent = '{{ planIntent }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
;