Dynamic filter for Ecto Preload

[fuelen]

Hey

This thread looks similar, check it out

Dynamically select a field using two tables

Hello. I didn’t run this snippet, but I think idea should work query = from s in Sales, as: :sales, inner_join: c in Cashier, on: s.cashier_id == c.i, as: :cachier, select: %{ count_sales: count_distinct(s.id), amount: sum(s.amount) } {binding_name, field_name} = if date_field == :sales_date do {:sales, :sales_date} else {:cachier, :cachier_date} end query |> where([{^binding_name, table}], extract_year(field(table, ^fiel…