Differences

This shows you the differences between two versions of the page.

--- b_i:use_of_in_with_complex_identifiers [2023/03/09 22:10] – sean
+++ b_i:use_of_in_with_complex_identifiers [2023/05/10 01:29] (current) – sean
@@ Line 1: / Line 1: @@
 {{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 ====
-<columns 100% 4% 48%>
+<grid>
-<hidden> DO NOT PLACE TEXT HERE</hidden>
+<col sm="1"><invisible> This is a spacer column</invisible></col>
-<newcolumn>
-===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>
-<newcolumn>
+<col sm="5">===Problem/Limitation Description===
-===Work Around===
+''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
-<newcolumn>
+</col>
-</columns>
+</grid>