Differences

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

--- tutorials:xl-queries-and-operators [2024/12/06 00:52] – [Query examples] ksmolen
+++ tutorials:xl-queries-and-operators [2025/01/10 11:17] (current) – gaetan
@@ Line 48: / Line 48: @@
 </code>
-We create a new method called ''analyse()''. The method will appear as a new button in the RGG toolbar. Inside this method, we first call the ''run()'' method for 3 steps. The result is a simple plant made of 3 internodes and 3 leaves.
+We create a new method called ''analyse()''. The method will appear as a new button in the RGG toolbar. Before running the ''analyse()'' method, press the ''Reset'' button in the RGG Toolbar, to reset the graph structure. Inside this method, we first call the ''run()'' method for 3 steps. The result is a simple plant made of 3 internodes and 3 leaves.
 {{ :tutorials:testplant_crop.png?100|}}
@@ Line 60: / Line 60: @@
 }
 </code>
+The underlying 2d graph of the generated structure given below:
+{{ :tutorials:graph_query_example_2.png?620|}}
+Beginning from //RGGRoot//, we have the sequence of three //Internodes// where to each is a //Leaf// linked by a branching edge. The last internode, additionally, has a Bud node successor.
 ==== Query examples ====
-Replace the text inside the ''println()'' one by one by the queries below.
+Replace the text (in red) inside the ''println()'' one by one by the queries below.
+Below each query, there is a result of the print command, for illustration. Note, that the ids will differ with different model execution.
   * Find all the internodes in the structure:
@@ Line 72: / Line 81: @@
 The query will return ids of all the internodes in the plant structure.
+<hidden answer>
+Model.Internode[id=1911]@ecc95fb
+Model.Internode[id=1906]@7b431a06
+Model.Internode[id=1901]@5753e950
+__Note:__
+Internode with the id=1901 is the first internode from the bottom (with the highest age: 3).
+Internode with the id=1911 is the top internode (with the lowest age: 1)
+</hidden>
 Notice, that when you click with a mouse on an internode in the 3D View window, information about the selected internode will be displayed in the Attribute Editor. In the Attribute Editor, you can check the internode id (e.g. Model$Internode [Internode.1756]) and compare it with the one that was printed in the XL Console. Another option is to look at the node ids in the 2D Graph (Panels -> 2D -> Graph, in the graph window: View -> Redraw).
@@ Line 81: / Line 104: @@
 </code>
-  * Find the internode closest to the bud:
+<hidden answer>
+Model.Internode[id=1911]@ecc95fb
+</hidden>
+  * Find the internode below the bud:
 {{ :tutorials:testplant_graph.png?150|}}
@@ Line 89: / Line 116: @@
 </code>
-''<'' represents a successor edge
+''<'' represents a successor edge in the indicated direction
+<hidden answer>
+Model.Internode[id=1911]@ecc95fb
+</hidden>
+  * Find all leaves connected to an internode:
+<code java>
+(* Internode +> RL > Leaf *)
+</code>
+This is just to illustrate how to define different edge types inside a query. ''+>'' represents a branch edge.
+<hidden answer>
+Model.Leaf[id=1913]@4b0f7bd
+Model.Leaf[id=1908]@1c6dbfa5
+Model.Leaf[id=1903]@668c1f97
+__Note:__
+Leaf with the id=1903 is the first (and the oldest) leaf, leaf with the id=1913 is the last (and the yongest) leaf.
+</hidden>
+==== Aggregators ====
+Aggregate operations are used to collect multiple values when traversing the graph structure and return a single value.
+Standard [[:groimp-platform:xl-builtin-methods|aggregate operations]] are: ''count'', ''sum'', ''empty'', ''exist'', ''forall'', ''first'', ''last'', ''max'', ''min'', ''mean'', ''selectRandomly'', ''selectWhereMin'', ''selectWhereMax'', ...
+  * Count all leaves:
+<code java>
+count((* Leaf *))
+</code>
+<hidden answer>
+</hidden>
+  * Sum up the area of all leaves:
+<code java>
+sum((* Leaf *)[area])
+</code>
+<hidden answer>
+.0
+</hidden>
+  * Sum up the length of internodes:
+<code java>
+sum((* Internode *)[length])
+</code>
+<hidden answer>
+.0
+</hidden>
+In this particular example with internodes forming (only) the main stem, the query will return stem length.
+  * Select the leaf with the highest leaf area:
+<code java>
+selectWhereMax((* l:Leaf *), (l[area]))
+</code>
+<hidden answer>
+Model.Leaf[id=1903]@668c1f97
+</hidden>
+  * Count internodes that are older than 2 (time units):
+<code java>
+count((* i:Internode, (i[age] >= 2) *))
+</code>
+<hidden answer>
+</hidden>