This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| b_i:use_of_in_with_complex_identifiers [2023/03/10 02:57] – sean | b_i:use_of_in_with_complex_identifiers [2023/05/10 01:29] (current) – sean |
|---|
| {{tag>Known_Issues, Issue:IN, Issue:Query}} | {{tag>Known_Issues, Issue:IN, Issue:Query}} |
| <hidden> This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page</hidden> | <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 ==== | ==== Use Of IN With Complex Identifiers ==== |
| <grid> | <grid> |
| <col sm="1"><hidden> This is a spacer column</hidden></col> | <col sm="1"><invisible> This is a spacer column</invisible></col> |
| |
| <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> |
| |
| <col sm="1"><hidden> This is a spacer column</hidden></col> | <col sm="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Work Around=== | <col sm="5">===Work Around=== |