Class ListSqlTextsRequest
Implements
Inherited Members
Namespace: Oci.OpsiService.Requests
Assembly: OCI.DotNetSDK.Opsi.dll
Syntax
public class ListSqlTextsRequest : IOciRequest
Examples
Click here to see an example of how to use ListSqlTexts request.
Properties
CompartmentId
Declaration
[Required(ErrorMessage = "CompartmentId is required.")]
[HttpConverter(TargetEnum.Query, "compartmentId")]
public string CompartmentId { get; set; }
Property Value
Type | Description |
---|---|
string | The OCID of the compartment. |
Remarks
Required
CompartmentIdInSubtree
Declaration
[HttpConverter(TargetEnum.Query, "compartmentIdInSubtree")]
public bool? CompartmentIdInSubtree { get; set; }
Property Value
Type | Description |
---|---|
bool? | A flag to search all resources within a given compartment and all sub-compartments. |
DatabaseId
Declaration
[HttpConverter(TargetEnum.Query, "databaseId", CollectionFormatType.Multi)]
public List<string> DatabaseId { get; set; }
Property Value
Type | Description |
---|---|
List<string> | Optional list of database OCIDs of the assosicated DBaaS entity. |
DefinedTagEquals
Declaration
[HttpConverter(TargetEnum.Query, "definedTagEquals", CollectionFormatType.Multi)]
public List<string> DefinedTagEquals { get; set; }
Property Value
Type | Description |
---|---|
List<string> | A list of tag filters to apply. Only resources with a defined tag matching the value will be returned. Each item in the list has the format "{namespace}.{tagName}.{value}". All inputs are case-insensitive. Multiple values for the same key (i.e. same namespace and tag name) are interpreted as "OR". Values for different keys (i.e. different namespaces, different tag names, or both) are interpreted as "AND". |
DefinedTagExists
Declaration
[HttpConverter(TargetEnum.Query, "definedTagExists", CollectionFormatType.Multi)]
public List<string> DefinedTagExists { get; set; }
Property Value
Type | Description |
---|---|
List<string> | A list of tag existence filters to apply. Only resources for which the specified defined tags exist will be returned. Each item in the list has the format "{namespace}.{tagName}.true" (for checking existence of a defined tag) or "{namespace}.true". All inputs are case-insensitive. Currently, only existence ("true" at the end) is supported. Absence ("false" at the end) is not supported. Multiple values for the same key (i.e. same namespace and tag name) are interpreted as "OR". Values for different keys (i.e. different namespaces, different tag names, or both) are interpreted as "AND". |
FreeformTagEquals
Declaration
[HttpConverter(TargetEnum.Query, "freeformTagEquals", CollectionFormatType.Multi)]
public List<string> FreeformTagEquals { get; set; }
Property Value
Type | Description |
---|---|
List<string> | A list of tag filters to apply. Only resources with a freeform tag matching the value will be returned. The key for each tag is "{tagName}.{value}". All inputs are case-insensitive. Multiple values for the same tag name are interpreted as "OR". Values for different tag names are interpreted as "AND". |
FreeformTagExists
Declaration
[HttpConverter(TargetEnum.Query, "freeformTagExists", CollectionFormatType.Multi)]
public List<string> FreeformTagExists { get; set; }
Property Value
Type | Description |
---|---|
List<string> | A list of tag existence filters to apply. Only resources for which the specified freeform tags exist the value will be returned. The key for each tag is "{tagName}.true". All inputs are case-insensitive. Currently, only existence ("true" at the end) is supported. Absence ("false" at the end) is not supported. Multiple values for different tag names are interpreted as "AND". |
Id
Declaration
[HttpConverter(TargetEnum.Query, "id", CollectionFormatType.Multi)]
public List<string> Id { get; set; }
Property Value
Type | Description |
---|---|
List<string> | Optional list of database OCIDs of the database insight resource. |
OpcRequestId
Declaration
[HttpConverter(TargetEnum.Header, "opc-request-id")]
public string OpcRequestId { get; set; }
Property Value
Type | Description |
---|---|
string | Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID. |
Page
Declaration
[HttpConverter(TargetEnum.Query, "page")]
public string Page { get; set; }
Property Value
Type | Description |
---|---|
string | For list pagination. The value of the |
SqlIdentifier
Declaration
[Required(ErrorMessage = "SqlIdentifier is required.")]
[HttpConverter(TargetEnum.Query, "sqlIdentifier", CollectionFormatType.Multi)]
public List<string> SqlIdentifier { get; set; }
Property Value
Type | Description |
---|---|
List<string> | One or more unique SQL_IDs for a SQL Statement. Example: 6rgjh9bjmy2s7 |
Remarks
Required