This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| ref:b_i:function_limitations_in_subqueries [2026/08/13 00:42] – ↷ Page moved from b_i:function_limitations_in_subqueries to ref:b_i:function_limitations_in_subqueries localdev | ref:b_i:function_limitations_in_subqueries [2026/08/13 07:11] (current) – external edit 127.0.0.1 |
|---|
| ==== Function Limitations In Subqueries ==== | ==== Function Limitations In Subqueries ==== |
| |
| <grid> | <row> |
| <col sm="1"><invisible> This is a spacer column</invisible></col> | <col size="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Problem/Limitation Description=== | <col size="5">===Problem/Limitation Description=== |
| ''MIN'', ''MAX'' and ''AVG'' expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:<code aim>FIND Account WHERE (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000)) </code> </col> | ''MIN'', ''MAX'' and ''AVG'' expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:<code aim>FIND Account WHERE (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000)) </code> </col> |
| |
| <col sm="1"><invisible> This is a spacer column</invisible></col> | <col size="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Work Around=== | <col size="5">===Work Around=== |
| Avoid using these expressions in subqueries | Avoid using these expressions in subqueries |
| </col> | </col> |
| </grid> | </row> |
| |
| |