Skip to content

Commit 1d0749d

Browse files
DelazJnyalldawson
authored andcommittedAug 9, 2020
Extend aggregate's concatenator and order_by args description
1 parent 57b620c commit 1d0749d

File tree

5 files changed

+8
-8
lines changed

5 files changed

+8
-8
lines changed
 

‎resources/function_help/json/aggregate

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@
99
{"arg":"expression", "description":"sub expression or field name to aggregate"},
1010
{"arg":"filter", "optional":true, "description":"optional filter expression to limit the features used for calculating the aggregate. Fields and geometry are from the features on the joined layer. The source feature can be accessed with the variable @parent."},
1111
{"arg":"concatenator", "optional":true, "default":"''", "description":"optional string to use to join values for 'concatenate' aggregate"},
12-
{"arg":"order_by", "optional":true, "description":"optional filter expression to order the features used for calculating the aggregate. Fields and geometry are from the features on the joined layer. By default, no sort is done"}
12+
{"arg":"order_by", "optional":true, "description":"optional filter expression to order the features used for calculating the aggregate. Fields and geometry are from the features on the joined layer. By default, the features will be returned in an unspecified order."}
1313
],
1414
"examples": [
1515
{ "expression":"aggregate(layer:='rail_stations',aggregate:='sum',expression:=\"passengers\")", "returns":"sum of all values from the passengers field in the rail_stations layer"},

‎resources/function_help/json/array_agg

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
{"arg": "expression", "description": "sub expression of field to aggregate"},
88
{"arg": "group_by", "optional": true, "description": "optional expression to use to group aggregate calculations"},
99
{"arg": "filter", "optional": true, "description": "optional expression to use to filter features used to calculate aggregate"},
10-
{"arg": "order_by", "optional": true, "description": "optional expression to use to order features used to calculate aggregate"}
10+
{"arg": "order_by", "optional": true, "description": "optional expression to use to order features used to calculate aggregate. By default, the features will be returned in an unspecified order."}
1111
],
1212
"examples": [
1313
{ "expression": "array_agg(\"name\",group_by:=\"state\")", "returns":"list of name values, grouped by state field"}

‎resources/function_help/json/concatenate

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,8 +7,8 @@
77
{"arg":"expression", "description":"sub expression of field to aggregate"},
88
{"arg":"group_by", "optional":true, "description":"optional expression to use to group aggregate calculations"},
99
{"arg":"filter", "optional":true, "description":"optional expression to use to filter features used to calculate aggregate"},
10-
{"arg":"concatenator", "optional":true, "description":"optional string to use to join values"},
11-
{"arg":"order_by", "optional":true, "description":"optional expression to use to order features used to calculate aggregate"}
10+
{"arg":"concatenator", "optional":true, "default":"''", "description":"optional string to use to join values"},
11+
{"arg":"order_by", "optional":true, "description":"optional expression to use to order features used to calculate aggregate. By default, the features will be returned in an unspecified order."}
1212
],
1313
"examples": [
1414
{ "expression":"concatenate(\"town_name\",group_by:=\"state\",concatenator:=',')", "returns":"comma separated list of town_names, grouped by state field"}

‎resources/function_help/json/concatenate_unique

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,8 +7,8 @@
77
{"arg":"expression", "description":"sub expression of field to aggregate"},
88
{"arg":"group_by", "optional":true, "description":"optional expression to use to group aggregate calculations"},
99
{"arg":"filter", "optional":true, "description":"optional expression to use to filter features used to calculate aggregate"},
10-
{"arg":"concatenator", "optional":true, "description":"optional string to use to join values"},
11-
{"arg":"order_by", "optional":true, "description":"optional expression to use to order features used to calculate aggregate"}
10+
{"arg":"concatenator", "optional":true, "default":"''", "description":"optional string to use to join values"},
11+
{"arg":"order_by", "optional":true, "description":"optional expression to use to order features used to calculate aggregate. By default, the features will be returned in an unspecified order."}
1212
],
1313
"examples": [
1414
{ "expression":"concatenate(\"town_name\",group_by:=\"state\",concatenator:=',')", "returns":"comma separated list of unique town_names, grouped by state field"}

‎resources/function_help/json/relation_aggregate

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,8 +7,8 @@
77
{"arg":"relation", "description":"a string, representing a relation ID"},
88
{"arg":"aggregate", "description":"a string corresponding to the aggregate to calculate. Valid options are:<br /><ul><li>count</li><li>count_distinct</li><li>count_missing</li><li>min</li><li>max</li><li>sum</li><li>mean</li><li>median</li><li>stdev</li><li>stdevsample</li><li>range</li><li>minority</li><li>majority</li><li>q1: first quartile</li><li>q3: third quartile</li><li>iqr: inter quartile range</li><li>min_length: minimum string length</li><li>max_length: maximum string length</li><li>concatenate: join strings with a concatenator</li><li>concatenate_unique: join unique strings with a concatenator</li><li>collect: create an aggregated multipart geometry</li><li>array_agg: create an array of aggregated values</li></ul>"},
99
{"arg":"expression", "description":"sub expression or field name to aggregate"},
10-
{"arg":"concatenator", "optional":true, "description":"optional string to use to join values for 'concatenate' aggregate"},
11-
{"arg":"order_by", "optional":true, "description":"optional expression to order the features used for calculating the aggregate. Fields and geometry are from the features on the joined layer."}
10+
{"arg":"concatenator", "optional":true, "default":"''", "description":"optional string to use to join values for 'concatenate' aggregate"},
11+
{"arg":"order_by", "optional":true, "description":"optional expression to order the features used for calculating the aggregate. Fields and geometry are from the features on the joined layer. By default, the features will be returned in an unspecified order."}
1212
],
1313
"examples": [
1414
{ "expression":"relation_aggregate(relation:='my_relation',aggregate:='mean',expression:=\"passengers\")", "returns":"mean value of all matching child features using the 'my_relation' relation"},

0 commit comments

Comments
 (0)
Please sign in to comment.