Use Of IN With Complex Identifiers AwareIM Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

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