johninvictus
Hi Guys.
Am trying to fetch data from database where date string is 2days old and I have no Idea how to use the function I have written inside the ecto query.
function
def date_difference(date_string) do
duration =
date_string
|> Timex.parse!("%Y-%m-%d", :strftime)
|> Timex.to_datetime()
|> DateTime.to_unix(:milliseconds)
|> Timex.Duration.from_microseconds()
Duration.diff(duration, Duration.zero(), :days)
end
I hoped to use it like this.
where: date_difference(p.payment_schedue) == 2
PS: Am a noobe ![]()
Trending in Questions
Hello everyone!
I am new to coding with Elixir/Erlang. And i am looking for some utilities for fuzzing testing like AFL++.
Does anyone ...
New
I’m very new to Elixir, so sorry if this is a silly question:
I am wondering what happens to the mailbox of a process when the machine i...
New
How do I tell Hologram not to escape HTML when substituting into templates?
{Textile.render(@product.long_description)}
escapes the HTM...
New
Background
When trying to execute mix release on a Windows 11 machine for a Phoenix project I get the following error:
* assembling mark...
New
I load tested a plain Phoenix chat app backed by Postgres with 100 million messages in it, everything on default settings, to see what br...
New
I’d like to create a file with 600 permissions (rw-------), but there’s a race condition if I create it and then change the permissions. ...
New
Is there a way to import record definitions in the iex shell for pretty printing (similar to the rr command in the erl shell)? This woul...
New
Other Trending Topics
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
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly)
AI dream has many faces, but general...
New
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
Hi everyone :waving_hand:
I’ve been working on PhiaUI, an open-source UI component library for Phoenix LiveView, and I wanted to share i...
New
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #elixirconf-us
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #security
- #elixirconf-eu
- #processes
- #api
- #forms
- #hex










Showing Posts 1 to 10- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
jswny
I’m certainly not an Ecto expert, but I’m pretty sure that you can’t define custom functions in Elixir and use them inside Ecto queries (feel free to correct me if I’m wrong though).
What I would do for now is get your results and use a filter function to do what you want. Something like this
That way, you will get all of the results initially from the Ecto query, and then you will use Elixir to filter those based on your custom Elixir function. This might not be the best way to do it but I am fairly sure it would work.
johninvictus
@jswny
Thank you for your answer.
After more research I have discovered it is not possible to use functions inside the query unless we use the Postgres defined types.
This is a great solution but I have chosen to refactor my db to use date and then use the interval type .
ie
OvermindDL1
If you want interval’s I have a type library here:
/me loves intervals
shakram02
What if I want to call a custom function?, for example; I want to check for 3 conditions when I’m joining two tables. Since this is lots of typing, I want to put that in a function.
However, the compiler complains that the binding variable is undefined.
But I get the following error where the call occrus (the ecto join)
Can this be accomplished using Ecto?
thanks! (newbie here)
LostKobrakai
You‘ll need to provide this logic in sql. You cannot use elixir code within an ecto query. A query will be converted to sql and sent to the db.
johninvictus
Hi @shakram02
This not possible.
Am not sure what those conditions are but I would suggest using and or or to join those conditions. ie
Hope that helps.
OvermindDL1
For note, a large set of
ilike’s like that is going to be very slow especially as the data set grows. Converting it to using TS indexes or so would be a lot faster and various other lookup patterns for the others.johninvictus
Hi @OvermindDL1
Thanks for the tip.
Do, you mean creating index with
Ecto.Migration.index/2:.OvermindDL1
Look at the tsvector/tsquery/etc types in PostgreSQL for efficient word style searches.
I think someone made a library on hex.pm that simplifies it as well, but it’s optional, you can do it in straight Ecto too, but might be worth finding it.
johninvictus
Thanks a lot, lemme look at that.