, ,

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

Use Of IN With Complex Identifiers

<invisible> This is a spacer column</invisible>

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

<invisible> This is a spacer column</invisible>

===Work Around=== Avoid using such constructs in queries