Parameters, Value
Minimum value function finds the greatest value of a column of data. It only keeps the data column as well as its homologous columns after aggregation, and it abandons other columns.
Syntax:
- Format: max(
<column>) - Parameters: see table below
- Value: ATTR ( number, time, string )
| Name | Category | Specification | Description |
|---|---|---|---|
<column> |
NODE，EDGE，PATH，ATTR，ARRAY，TABLE | / | The column to be aggregated |
The value of <column> with different categories in every row:
| Type | Value |
|---|---|
| NODE | Node's UUID in the row |
| EDGE | Edge's UUID in the row |
| PATH | ROW INDEX（starts from 0）in the row |
| ATTR | ATTR's value in the row |
| ARRAY | The value of the 1st element in the array of the row |
| TABLE | ROW INDEX（starts from 0）in the row |
ATTR (Numeric value)
Example: find the outbound 1-step paths from Card CA001, then find the smallest amount of money transferred
n({_id == "CA001"}).re({@transfer} as pay).n({@card})
return min(pay.amount)
ATTR (String)
Example: find the outbound 1-step paths from Card CA001, then find the smallest payee cards' ID
n({_id == "CA001"}).re({@transfer}).n({@card} as payee)
return min(payee._id)
ATTR (time)
Example: find the outbound 1-step paths from Card CA001, then find the minimum time value of the transfers
n({_id == "CA001"}).re({@transfer} as pay).n({@card})
return min(pay.time)