When the system template cannot meet actual project needs, users can define commonly used detect SQL statements as Template for reuse in the project.
Create Custom Templates
Support users to create custom monitoring rules templates via SQL expression.
1. Go to Rule Templates > Custom Template, click the Add button, and the template creation window will pop up.
2. On the template creation interface, configure the template dimension, applicable object, template description, and SQL expression to complete template creation.
Fill an SQL statement with preset parameter variables to meet more usage scenarios.
Note:
The execution result must be one row and one column, meaning it must be a fixed value (can be a character or numeric value).
If the result is multi-row, the system will automatically take the first one.
You may preset parameter variables in SQL for the actual user to fill the value.
1. Current detection rule associated with primary table: ${table_1};
2. Fields in the primary table associated with the current detection rule: ${table_1.column_1}, ${table_1.column_2}...${table_1.column_n};
3. Supports association with one other table from the same database of the same data source: ${table_2} or ${table_3}...${table_n}. Note only one table is supported.
4. Fields associated with other tables: ${table_2.column_1}, ${table_2.column_2}...${table_2.column_n};
5. Set where filter parameters: use ${param_1}...${param_n};
6. Use time parameters, for example: ${yyyy-MM-dd-1d}.
