# Rules Expression Examples ### 1. Expanded / Compressed Pattern Rule **Example:** Column: **ZipCode** Requirement: ZipCode should have 4 or 5 digits only. * **Input Variable**: `Var_1` (mapped to column ZipCode) * **Static Variable**: `valid_zip` (List type: \["DDDD", "DDDDD"]) | Expression | List Type | Sample Value | Expected Result | | ---------------------------------------------------------------------- | ------------------- | ------------ | --------------- | | `validate Var_1 expect expanded_pattern IN valid_zip` | \["DDDD", "DDDDD"] | 1234 | True | | `validate Var_1 expect expanded_pattern IN valid_age` | \["D", "DD", "DDD"] | 1008 | False | | `validate Var_1 expect compressed_pattern IN valid_compressed_pattern` | \["DLD"] | 123ab9 | True | ### 2. Range Rule **Example:** Column: **Age** Requirement: Age should be between 18 and 60. * **Input Variable**: `Var_2` (mapped to column Age) * **Expression**: `validate Var_2 expect numeric_value in_range (18, 60)` | Sample Value | Expected Result | | ------------ | --------------- | | 25 | True | | 17 | False | ### 3. Regex Pattern Rule **Example:** Column: **Email** Requirement: Email should be in valid format. * **Input Variable**: `Var_3` (mapped to column Email) | Expressions | Sample Value | Expected Result | | -------------------------------------------------------------------------------- | ------------------ | --------------- | | `Validate var_3 expect regex('^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,}$')` | | True | | `Validate var_3 expect regex('^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,}$')` | invalid-email.com | False | | `validate var_3 expect regex('\d+')` | 123456789 | True | ### 4. Length Rule **Example:** Column: **Username** Requirement: Username should be between 5 to 15 characters long. * **Input Variable**: `Var_4` (mapped to column Username) | Expressions | Sample Value | Expected Result | | ---------------------------------------------- | ------------------------ | --------------- | | `validate Var_4 expect length in_range(5, 15)` | JohnD | True | | `validate Var_4 expect length in_range(5, 15)` | JD | False | | `validate Var_4 expect length=5` | India | True | | `validate Var_4 expect length<>5` | India | False | | `validate Var_4 expect spec_char_count=1` | NY 10011, USA | True | | `validate Var_4 expect space_count<=1` | United States Of America | False | | `validate Var_4 expect frequency=1` | India | True | ### 5. List Rule **Example:** Column: **Country** Requirement: Country should be either USA, Canada, or UK. * **Input Variable**: `Var_5` (mapped to column Country) * **Static Variable**: `valid_countries` (List type: \["USA", "Canada", "UK"]) | Expressions | Sample Value | Expected Result | | ---------------------------------------------------- | ------------ | --------------- | | `validate Var_5 expect Value IN valid_countries` | USA | True | | `validate Var_5 expect value IN valid_countries` | Germany | False | | `validate Var_5 expect value not_in valid_countries` | India | True | ### 6. Null Rule **Example:** Column: `Var_6` Requirement: Validate different null handling scenarios. * **Input Variable:** `Var_6` | Expression | Sample Value | Expected Result | | -------------------------------------------------------- | ------------ | --------------- | | `validate Var_6 expect is_null` | None | False | | `validate Var_6 expect is_null` | \_\_null\_\_ | True | | `validate Var_6 expect not is_null` | \_\_null\_\_ | False | | `validate Var_6 expect not is_null` | 12345 | True | | `validate Var_6 expect not is_null` | (Empty) | (Empty) | | `validate if(Var_6 is null, true, false) expect is_true` | \_\_null\_\_ | True | ### 7. Custom Condition Rule **Example:** Column: **Salary** Requirement: If the job title is "Manager", the salary should be greater than 50,000. * **Input Variables**: `Var_7` (mapped to column JobTitle), `Var_8` (mapped to column Salary) * **Expression**: `validate case when Var_7 == 'Manager' then Var_8> 5000 else false end expect is_true` | Job Title | Salary | Expected Result | | --------- | ------ | --------------------- | | Manager | 60000 | True | | Developer | 45000 | True (Not applicable) | | Manager | 40000 | False | ### 8. Date Format Rule **Example:** Column: **TransactionDate** Requirement: Date should be in YYYY-MM-DD format. * **Input Variable**: `Var_8` (mapped to column TransactionDate) | Expression | Sample Value | Expected Result | | --------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- | --------------- | | `validate Var_8 expect is_date` | 2024-02-01 | True | | `validate Var_8 expect is_date` | 2021-01-01T00:00:00Z | False | | `validate Var_8 expect is_date_time` | 2011/12/03 10:15:30 | True | | `validate Var_8 expect date_time_value in_range valid_datetime` |

Static Variable ⇒ Date Time Range
From=-2d, To=@now
Sample Value ⇒ 2025-07-16 05:24:36.441

| True | *** This documentation provides a structured guide for different rule expressions, helping users understand rule syntax, sample values, and expected outcomes. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.telm.ai/telmai/monitoring-data/user-defined-monitors/record-validation-rules/rules-expression-examples.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.