Differences

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

--- b_i:function_limitations_in_subqueries [2023/03/09 03:35] – ↷ Page moved from b_l:function_limitations_in_subqueries to b_i:function_limitations_in_subqueries sean
+++ b_i:function_limitations_in_subqueries [2023/05/10 01:25] (current) – sean
@@ Line 1: / Line 1: @@
-{{tag>Known_Issues, Issue:Min, Issue:Max, Issue:Avg, Issue:Sub_Queries, Issue:Queries}}
+{{tag>Known_Issues, Issue:Min, Issue:Max, Issue:Avg, Issue:Sub_Query, 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>
 ==== Function Limitations In Subqueries ====
-<columns 100% 4% 48%>
-<hidden> DO NOT PLACE TEXT HERE</hidden>
+<grid>
-<newcolumn>
+<col sm="1"><invisible> This is a spacer column</invisible></col>
-===Problem/Limitation Description===
-''MIN'', ''MAX'' and ''AVG'' expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:<code aim>FIND Account WHERE  (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000)) </code>
+<col sm="5">===Problem/Limitation Description===
-<newcolumn>
+''MIN'', ''MAX'' and ''AVG'' expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:<code aim>FIND Account WHERE  (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000)) </code> </col>
-===Work Around===
+<col sm="1"><invisible> This is a spacer column</invisible></col>
+<col sm="5">===Work Around===
 Avoid using these expressions in subqueries
-<newcolumn>
+</col>
-</columns>
+</grid>