This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| b_i:use_of_in_with_complex_identifiers [2023/05/10 01:28] – sean | b_i:use_of_in_with_complex_identifiers [2023/05/10 01:29] (current) – sean |
|---|
| |
| <col sm="5">===Problem/Limitation Description=== | <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> | ''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> |