Is there a way to use custom/varying column names in fragment? I mean the situation where I have 2 almost similar tables coming from different databases. Only couple of columns are different for historical reasons and I use those column names inside fragment(s). I want to unify Ecto queries to both …

@kip Thanks for the suggestion, actually I am looking for something like: CheapestConnection |> where([cc], cc.kind == "round_trip_recent") |> order_by([cc], fragment("abs(date_part('day', ? - ?)), price", custom_column_name, type(^datetime, :utc_datetime))) |> CheapestConnectionsRepo.all() As…

You can solve this by defining the same field with different sources in schemas defmodule Schema1 do schema "table1" do field(:custom_column_name, :utc_datetime, source: :column_name1 end end defmodule Schema2 do schema "table2" do field(:custom_column_name, :utc_datetime, source: :co…

@fuelen Thanks a lot! Yes, that solves the problem.

Elixir Programming Language Forum

Custom column names in fragment

Questions & Help Questions

kip September 5, 2019, 7:13am 2

Would:

fragment("abs(date_part('day', departure_date - ?)) as day, price"

work?