I have a couple of organizations in my company that has associated "group categories" assigned to them with individual priority_level's. I have a query with WHERE gc.priority_level = (SELECT MIN(gc_inner.priority_level) ...), as first_category and WHERE gc.priority_level = (SELECT MAX(gc_inner.priority_level) ...),…
I have a function in Elixir using Ecto that preloads associations for a given entity. The current implementation looks like this: @spec get(integer() | String.t(), list()) :: t() | nil def get(id, preloads \ []) do Shop |> Repo.get(id) |>…
In my Ecto schema, I have a User who has_many Items. An item has a boolean field active: User module: schema "users" do field :name, :string has_many :items, Item end Item module: schema "items" do field(:active, :boolean) belongs_to(:user, User) end…