Problem/Limitation Description

IN expressions using complex identifier of the reference list are not supported if used in subqueries. For example, the following query is not supported:

FIND Client WHERE  (COUNT Account WHERE (Account IN Client.Carrier.Accounts) > 3) 

Note that the following query is supported:

FIND Client WHERE (COUNT Account WHERE (Account IN Client.Accounts)>3) 

Work Around

Avoid using such constructs in queries