Function Limitations In Subqueries AwareIM Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{tag>Known_Issues, Issue:Min, Issue:Max, Issue:Avg, Issue:Sub_Query, Issue:Query}}
<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 ====

<grid>
<col sm="1"><invisible> This is a spacer column</invisible></col>

<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>

<col sm="1"><invisible> This is a spacer column</invisible></col>

<col sm="5">===Work Around===
Avoid using these expressions in subqueries
</col>
</grid>