Rules
A Rule defines how one output column of a modeled View Object is produced: passed through, renamed, cast, derived from an expression, aggregated, looked up or set to a constant. Rules belong to a Rule Set and are listed in output column order.
The Rule Sets and Rule References that a Rule relates to have their own pages.
Overview
Property | Description |
|---|---|
| Name | The name of the output column that this Rule produces, unique within its Rule Set. |
| Expression | The SQL for the Rule, in the dialect of the target connection: the expression for a Derived rule, the target data type for a Cast, the aggregate for an Aggregate, the returned column for a Lookup or the value for a Constant. |
| Dialect Alternates Json | Alternate versions of the Expression for other target system types, stored as JSON and keyed by system type code. |
| Is Detached | When checked, the Rule keeps its own Expression and changes to its Library Rule do not reach it. The Rule still names the Library Rule, so the Library Rule lists every Rule it is applied to. |
| Is Hand Written | When checked, the Expression is written by hand and BimlFlex uses it as entered. |
| Is Ai Proposed | Indicates that AI proposed the Rule. |
| Parse State | The result of parsing the Expression: 0 when it has not been parsed, 1 when it parsed and its references resolved, 2 when parsing failed. Parse Error gives the reason for a 2. |
| Parse Error | The reason the Expression could not be parsed. |
| Ordinal | The position of the output column within the Rule Set. Rules are listed and generated in this order. |
| Description | Free-format description of the Rule. |
References
Property | Description |
|---|---|
| Rule Set | The Rule Set that this Rule belongs to. |
| Customer | Reference to the Customer that this Rule belongs to. |
| Version | Reference to the Version that this Rule belongs to. |
| Column | The output Column that this Rule produces. A Rule can be saved ahead of its Column and is matched to the Column by name. When the Column is deleted, the Rule stays and is shown as unbound. |
| Rule Kind | How the Rule produces its column: Pass Through, Rename, Cast, Derived, Aggregate, Lookup or Constant. |
| Library Rule | The Library Rule that this Rule applies. While the Rule is attached, BimlFlex takes the Expression and its Dialect Alternates from the Library Rule each time the view is generated. When the Library Rule is deleted, the Rule keeps its own Expression and the reference to the Library Rule is cleared. |