Builds an aggregate query with an aggregate method passed in the params as a string or list.

=> $sum/$avg

Parameters

• queryable - Ecto Queryable that represents your schema name, table name or query.
• query_opts - Aggregate query options as a map.

Examples

iex> query_opts = %{
...>  "$aggregate" => %{"$sum" => "total_staff", "$avg" => "rating"},
...>  "$where" => %{"rating" => 5},
...>  "$group" => "id" 
...> }   
iex> Elixir.MyApp.Query.build!(FatEcto.FatHospital, query_opts)
#Ecto.Query<from f0 in FatEcto.FatHospital, where: f0.rating == ^5 and ^true, group_by: [f0.id], select: merge(merge(f0, %{"$aggregate" => %{"$avg": %{^"rating" => avg(f0.rating)}}}), %{"$aggregate" => %{"$sum": %{^"total_staff" => sum(f0.total_staff)}}})>

Options

• $aggregate- Specify the type of aggregate method/methods to apply.
• $where - Added the where attribute in the query.
• $group - Group the records with a specific field.

=> $min/$max

Parameters

• queryable - Ecto Queryable that represents your schema name, table name or query.
• query_opts - Aggregate query options as a map.

Examples

iex> query_opts = %{
...>  "$aggregate" => %{"$min" => "total_staff", "$max" => "rating"},
...>  "$where" => %{"rating" => 5},
...>  "$group" => "id" 
...> }   
iex> Elixir.MyApp.Query.build!(FatEcto.FatHospital, query_opts)
#Ecto.Query<from f0 in FatEcto.FatHospital, where: f0.rating == ^5 and ^true, group_by: [f0.id], select: merge(merge(f0, %{"$aggregate" => %{"$max": %{^"rating" => max(f0.rating)}}}), %{"$aggregate" => %{"$min": %{^"total_staff" => min(f0.total_staff)}}})>

Options

• $aggregate- Specify the type of aggregate method/methods to apply.
• $where - Added the where attribute in the query.
• $group - Group the records with a specific field.

=> $count/$count_distinct

Parameters

• queryable - Ecto Queryable that represents your schema name, table name or query.
• query_opts - Aggregate query options as a map.

Examples

iex> query_opts = %{
...>  "$aggregate" => %{"$count" => ["total_staff"], "$count_distinct" => ["rating"]},
...>  "$where" => %{"rating" => 5},
...>  "$group" => "id" 
...> }   
iex> Elixir.MyApp.Query.build!(FatEcto.FatHospital, query_opts)
#Ecto.Query<from f0 in FatEcto.FatHospital, where: f0.rating == ^5 and ^true, group_by: [f0.id], select: merge(merge(f0, %{"$aggregate" => %{"$count": %{^"total_staff" => count(f0.total_staff)}}}), %{"$aggregate" => %{"$count_distinct": %{^"rating" => count(f0.rating, :distinct)}}})>

Options

• $aggregate - Specify the type of aggregate method/methods to apply.
• $where - Added the where attribute in the query.
• $group - Group the records with a specific field.