SelectAssoc options custom sort

[jaysson]

Looks like the option labels are sorted alphabetically.

formex_ecto/lib/custom_fields/select_assoc.ex

Line 290 in aa8a6ef

|> Enum.sort(fn {name1, _}, {name2, _} ->

How do I sort by a column?

** Context
I have a multi level/nested set of categories. These can be selected at any level using a SelectAssoc field.

Data

Deserts
-- Gluten Free
-- Vegetarian
Mains
-- Chicken

Form

|> add(
  :categories,
  SelectAssoc,
  label: "Categories",
  choice_label: fn category ->
    if category.parent_id do
      "-- #{category.name}"
    else
      category.name
    end
  end,
  query: fn query ->
    from c in query,
    order_by: [asc: :sort_value]
  end,
  validation: [:required]
)

However, it displays like this:

-- Gluten Free
-- Vegetarian
-- Chicken
Deserts
Mains

[jakub-zawislak]

Maybe you can make use of group_by option?
Anyway, custom sorting in selects is the must have in this library

[jaysson]

I did not need many to many relation, thus I could replace it with a simple select field with choices.