ALIYUN::ActionTrail::AdvancedQueryTemplate - Resource Orchestration Service

Syntax

{
  "Type": "ALIYUN::ActionTrail::AdvancedQueryTemplate",
  "Properties": {
    "SimpleQuery": Boolean,
    "TemplateSql": String,
    "TemplateName": String
  }
}

Properties

Parameter	Type	Required	Update allowed	Description	Constraints
SimpleQuery	Boolean	Yes	Yes	Specifies whether to enable simple query mode.	Valid values: true: Enabled false: Disabled
TemplateSql	String	Yes	Yes	The SQL statement for the template.	None
TemplateName	String	No	Yes	The template name.	None

Return values

Fn::GetAtt

TemplateId: The ID of the advanced query template.

Examples

YAML

ROSTemplateFormatVersion: '2015-09-01'
Parameters:
  TemplateSql:
    Type: String
    Description:
      en: The SQL statement for the template.
      zh: 高级查询模板的SQL语句。
    Required: true
  SimpleQuery:
    Type: Boolean
    Description:
      en: Specifies whether to enable simple query mode.
      zh: 指示该模板是否为简单查询。
    Required: true
Resources:
  AdvancedQueryTemplate:
    Type: ALIYUN::ActionTrail::AdvancedQueryTemplate
    Properties:
      TemplateSql:
        Ref: TemplateSql
      SimpleQuery:
        Ref: SimpleQuery
Outputs:
  TemplateId:
    Description:
      en: The ID of the advanced query template.
      zh: 高级查询模板的ID。
    Value:
      Fn::GetAtt:
        - AdvancedQueryTemplate
        - TemplateId

JSON

{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Parameters": {
    "TemplateSql": {
      "Type": "String",
      "Description": {
        "en": "The SQL statement for the template.",
        "zh": "高级查询模板的SQL语句。"
      },
      "Required": true
    },
    "SimpleQuery": {
      "Type": "Boolean",
      "Description": {
        "en": "Specifies whether to enable simple query mode.",
        "zh": "指示该模板是否为简单查询。"
      },
      "Required": true
    }
  },
  "Resources": {
    "AdvancedQueryTemplate": {
      "Type": "ALIYUN::ActionTrail::AdvancedQueryTemplate",
      "Properties": {
        "TemplateSql": {
          "Ref": "TemplateSql"
        },
        "SimpleQuery": {
          "Ref": "SimpleQuery"
        }
      }
    }
  },
  "Outputs": {
    "TemplateId": {
      "Description": {
        "en": "The ID of the advanced query template.",
        "zh": "高级查询模板的ID。"
      },
      "Value": {
        "Fn::GetAtt": [
          "AdvancedQueryTemplate",
          "TemplateId"
        ]
      }
    }
  }
}