{{tag>Known_Issues, Issue:IN, 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>

==== Use Of IN With Complex Identifiers ====
<grid>
<col sm="1"><invisible> This is a spacer column</invisible></col>

<col sm="5">===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:<code aim>FIND Client WHERE  (COUNT Account WHERE (Account IN Client.Carrier.Accounts) > 3) </code>Note that the following query is supported:<code aim>FIND Client WHERE (COUNT Account WHERE (Account IN Client.Accounts)>3) </code> 

</col>

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

<col sm="5">===Work Around===
Avoid using such constructs in queries 
</col>
</grid>