| Both sides previous revision Previous revision | |
| 3000_rule_language:0400_rule_language [2026/08/13 00:55] – ↷ Page moved from docs:3000_rule_language:0400_rule_language to 3000_rule_language:0400_rule_language localdev | 3000_rule_language:0400_rule_language [2026/08/13 07:33] (current) – Imported by DokuWiki Advanced Plugin aware_support3 |
|---|
| - ''AVG'' – calculate average value of an attribute | - ''AVG'' – calculate average value of an attribute |
| |
| <callout type="primary" icon="true" title="note"> | <alert type="primary" icon="fa info-circle"> |
| SUM, MIN, MAX, AVG calculations must not use attributes of the Reference type, for example the following expression is not valid:\\ ''SUM Account.Transactions.Amount''\\ IF aggregate of the referred object is required as in the example above, the following expression must be used:\\ ''SUM Transaction.Amount WHERE (Transaction IN Loan.Transactions)''</callout> | **note** |
| <callout type="primary" icon="true" title="note"> COUNT operation MUST only use the name of the business object, which it counts, for example, \\ <code aim>COUNT Account or COUNT Account WHERE (Account.State='Open') </code>. </callout> | |
| <callout type="primary" icon="true" title="note"> Using references is not allowed, for example the following construct is invalid:<code aim>COUNT Account.Transactions </code>The valid expression that achieves the desired result is:<code aim>COUNT Transaction WHERE (Transaction IN Account.Transactions) </code> | SUM, MIN, MAX, AVG calculations must not use attributes of the Reference type, for example the following expression is not valid:\\ ''SUM Account.Transactions.Amount''\\ IF aggregate of the referred object is required as in the example above, the following expression must be used:\\ ''SUM Transaction.Amount WHERE (Transaction IN Loan.Transactions)''</alert> |
| </callout> | <alert type="primary" icon="fa info-circle"> |
| | **note** |
| | |
| | COUNT operation MUST only use the name of the business object, which it counts, for example, \\ <code aim>COUNT Account or COUNT Account WHERE (Account.State='Open') </code>. </alert> |
| | <alert type="primary" icon="fa info-circle"> |
| | **note** |
| | |
| | Using references is not allowed, for example the following construct is invalid:<code aim>COUNT Account.Transactions </code>The valid expression that achieves the desired result is:<code aim>COUNT Transaction WHERE (Transaction IN Account.Transactions) </code> |
| | </alert> |
| |
| |
| <code aim>Transaction.Amount BETWEEN Account.Balance/2, 5000 </code> | <code aim>Transaction.Amount BETWEEN Account.Balance/2, 5000 </code> |
| |
| <callout type="primary" icon="true" title="note">both ranges are inclusive</callout> | <alert type="primary" icon="fa info-circle"> |
| | **note** |
| | |
| | both ranges are inclusive</alert> |
| |
| |
| |
| |
| <callout type="primary" icon="true" title="note"> When comparing new and old values of the attribute, the WAS CHANGED expression only checks whether the value has been changed compared to the value of the attribute in the //last stable version// of the business object. See the "[[2000_concepts:0800_data_processing:0100_rule_evaluation:0900_evaluation_was_changed_expressions|Evaluation of WAS CHANGED expressions]]" section for a more detailed explanation.</callout> | <alert type="primary" icon="fa info-circle"> |
| | **note** |
| | |
| | When comparing new and old values of the attribute, the WAS CHANGED expression only checks whether the value has been changed compared to the value of the attribute in the //last stable version// of the business object. See the "[[2000_concepts:0800_data_processing:0100_rule_evaluation:0900_evaluation_was_changed_expressions|Evaluation of WAS CHANGED expressions]]" section for a more detailed explanation.</alert> |
| |
| |