lkananowicz

lkananowicz

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 of those tables as they were executed separately before.

Using simple questionmark notation fragment("?", column_name) causes column name to be appended into fragment however column ends up wrapped into double-quotes which is not desired.

Here is an example:

{:ok, datetime} = DateEx.convert_date_to_datetime(date)

CheapestConnection
|> where([cc], cc.kind == "round_trip_recent")
|> order_by([cc], fragment("abs(date_part('day', departure_date - ?)), price", type(^datetime, :utc_datetime)))    
|> CheapestConnectionsRepo.all()

The column I would like to choose depending on certain conditions (like DB/Repo is used) is departure_date. That column name is different in another database. As a side note this query basically orders records by closest date relative to datetime.

Showing Posts 4 to 1

lkananowicz

lkananowicz OP

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

fuelen

fuelen

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: :column_name2
  end
end

schema_module
|> where([cc], cc.kind == "round_trip_recent")
|> order_by([cc], fragment("abs(date_part('day', ? - ?)), price", cс.custom_column_name, type(^datetime, :utc_datetime)))    
|> CheapestConnectionsRepo.all()
lkananowicz

lkananowicz OP

@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 I mentioned before custom_column_name will be wrapped into double-quotes which is not desired.

kip

kip

ex_cldr Core Team

Would:

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

work?

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
kpanic
Hi everyone, I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding. I sta...
New
nseaSeb
Hello, I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
brecabral
Documentation While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
asweet-confluent
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
apz
I’m new to elixir and just tried to install the elixirLS extension for VScode(ium) and it is throwing some errors that I would like help ...
New

Other Trending Topics Top

GenericJam
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
New
JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews