> For the complete documentation index, see [llms.txt](https://docs.telm.ai/telmai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.telm.ai/telmai/monitoring-data/user-defined-monitors/record-validation-rules/rules-expression-examples.md).

# 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,}$')` | <test@example.com> | 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` | <p>Static Variable ⇒ Date Time Range<br><strong>From</strong>=-2d, <strong>To</strong>=@now<br>Sample Value ⇒ 2025-07-16 05:24:36.441</p> | True            |

***

This documentation provides a structured guide for different rule expressions, helping users understand rule syntax, sample values, and expected outcomes.