Clear ORM
Search…
Welcome to Clear
Introduction
Setup
Model
Defining your model
Associations
Lifecycle
Batchs operations
Transactions & Save Points
Locks
Querying
The collection object
Filter the query
Filter the query – The Expression Engine
Find, First, Last, Offset, Limit
Aggregation
Ordering & Group by
Fetching the query
Joins
Eager Loading
Window and CTE
Scopes
Writing low-level SQL
Migrations
Manage migrations
Call migration script
Migration CLI
Additional and advanced features
JSONB
Symbol vs String
Enums
BCrypt
Full Text Search
Handling multi-connection
Other resources
API Documentation
Inline documentation
Github repository
Credits
Benchmark
Powered By
GitBook
Aggregation
Each collection have simple access to aggregation functions.
MIN, MAX, AVG and SUM
By default,
min
,
max
,
avg
,
sum
and
count
are mapped:
user_count
=
User
.
query
.
count
user_max_id
=
User
.
query
.
max
(
"id"
,
Int64
)
user_min_id
=
User
.
query
.
min
(
"id"
,
Int64
)
user_average_time
=
User
.
query
.
avg
(
"time_connected"
,
Float64
)
Custom aggregation method
You can call you own custom aggregation method using
agg
method:
time_squared
=
User
.
query
.
agg
(
"AVG(timesquared * timesquared)"
,
Float64
)
Previous
Find, First, Last, Offset, Limit
Next
Ordering & Group by
Last modified
2yr ago
Copy link
Outline
MIN, MAX, AVG and SUM
Custom aggregation method