Function Limitations In Subqueries AwareIM Documentation

This is an old revision of the document!

Known Issues,, Min,, Max,, Avg,, Sub Queries,, Queries

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

Work Around

Avoid using these expressions in subqueries <newcolumn> </columns>