Function Limitations In Subqueries [Documentation]

Known Issues,, Min,, Max,, Avg,, Sub Query,, Query

This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page

This is a spacer column

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:

FIND Account WHERE  (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000))

This is a spacer column

Work Around

Avoid using these expressions in subqueries