Message notification management

This topic describes how to configure notification for a project in OceanBase Developer Center (ODC).

Background information

Web ODC V4.2.4 allows a project member to add a notification channel to learn about changes in ticket events.

Channel types

ODC supports sending notifications by using DingTalk, Feishu, WeCom, and custom methods.

Message templates

ODC allows you to define notification templates separately in Simplified Chinese, Traditional Chinese, and English. By default, the notification templates are in the Markdown format.

• Simplified Chinese

  ### ODC ${taskType}-${taskStatus}
   - 任务ID: ${taskId}
   - 项目: ${projectName}
   - 数据库: ${databaseName}
   - 发起人: ${creatorName}
   - 触发时间: ${triggerTime}
  

• Traditional Chinese

  ### ODC ${taskType}-${taskStatus}
   - 任務ID: ${taskId}
   - 項目: ${projectName}
   - 數據庫: ${databaseName}
   - 發起人: ${creatorName}
   - 觸發時間: ${triggerTime}
  

• English

  ### ODC ${taskType}-${taskStatus}
   - task ID: ${taskId}
   - project: ${projectName}
   - database: ${databaseName}
   - creator: ${creatorName}
   - trigger time: ${triggerTime}
  

The following table describes the supported labels.

Configure message notification

Example: Create a DingTalk notification channel and add the channel for the Database Change-Approved event.

1. Log on to the ODC console. Choose Projects > Notification. On the Notification tab, choose Notification Channel > Create Notification Channel.

   

2. On the Create Notification Channel page, configure the channel information.

   

   Parameter	Description
   Channel Name	Enter the name of the channel.
   Channel Type	Select a channel type and obtain the corresponding webhook URL. DingTalk chatbot Feishu chatbot WeCom chatbot When you add a DingTalk or Feishu chatbot, you must enter ODC in the Custom Keywords field in the Security Settings section.
   Signature Key	The signature key of the DingTalk chatbot.
   Specified User	The mobile number of the user.
   Notification Template	Select a language for sending notifications.
   Notification Limit Settings	The number of times to send notifications within the specified period.
   Description	Optional. Additional information about the notification channel, which cannot exceed 200 characters in length.

3. Click Send Test Notification. If a test message is successfully sent, click Create.

   

4. On the Notification tab, click Notification Rules in the left-side navigation pane, and add the configured notification channel for the Database Change-Approved event.

   

References

• Project collaboration management

• Risk level, risk identification rule, and approval process management

• SQL check specifications

• SQL window specifications

• Create a data source

• Database change management

• Import schemas and data

• Export schemas and data

• Users and roles