RuleSets
A Rule Set holds the modeled business rules for one View Object: the inputs the view reads, the joins, filters and grouping between them, and one Rule for each output column. BimlFlex generates the view SQL from the Rule Set and stores it in the Source Create SQL of the Object.
The Rules and Rule References of a Rule Set have their own pages.
Overview
Property | Description |
|---|---|
| Name | The name of the Rule Set, unique within its Object. A new Rule Set takes the name of its Object. |
| Joins Json | The joins between the inputs of the Rule Set, stored as JSON. Each join names the two inputs it connects, the join type and the join condition. |
| Filters Json | The filter conditions applied to the inputs of the Rule Set, stored as JSON in the order they apply. |
| Grouping Json | The grouping applied to the output of the Rule Set, stored as JSON. Empty when the view returns one row for each input row. |
| Trailing Sql | An optional SELECT statement that runs over the modeled output, which it references as @@model. Use it for logic that the Rules do not express. |
| Trailing Sql References Json | The references BimlFlex resolved in the Trailing SQL, stored as JSON, including any reference it could not resolve and the Rules that the statement replaces. |
| Is Forked | When checked, the Source Create SQL of the Object is edited by hand and generating from the Rules leaves it unchanged. |
| Forked Date | The date and time of the fork. |
| Last Generated Sql | The SQL that BimlFlex last generated from this Rule Set and stored in the Source Create SQL of the Object. A fork starts from this SQL. |
| Previous Generated Sql | The SQL of the generation preceding the last one, kept so that the two can be compared. |
| Description | Free-format description of the Rule Set. |
| Comments | Generic comments for use by the Analyst and Modelers to keep notes related to the Rule Set. |
References
Property | Description |
|---|---|
| Object | The View Object that this Rule Set models. An Object has at most one Rule Set. |
| Customer | Reference to the Customer that this Rule Set belongs to. |
| Version | Reference to the Version that this Rule Set belongs to. |