| Both sides previous revision Previous revision | |
| b_i:function_limitations_in_subqueries [2023/03/10 02:44] – sean | b_i:function_limitations_in_subqueries [2023/05/10 01:25] (current) – sean |
|---|
| {{tag>Known_Issues, Issue:Min, Issue:Max, Issue:Avg, Issue:Sub_Query, Issue:Query}} | {{tag>Known_Issues, Issue:Min, Issue:Max, Issue:Avg, Issue:Sub_Query, Issue:Query}} |
| <hidden> This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page</hidden> | <invisible> This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page</invisible> |
| |
| ==== Function Limitations In Subqueries ==== | ==== Function Limitations In Subqueries ==== |
| |
| <grid> | <grid> |
| <col sm="1"><hidden> This is a spacer column</hidden></col> | <col sm="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Problem/Limitation Description=== | <col sm="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"><hidden> This is a spacer column</hidden></col> | <col sm="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Work Around=== | <col sm="5">===Work Around=== |