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) |> Time…

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 quer…

@jswny Thank you for your answer. [image] jswny: xpert, but I’m pretty sure that you can’t define custom functions in Elixir and use them inside Ecto querie After more research I have discovered it is not possible to use functions inside the query unless we use the Postgres defined types. …

If you want interval’s I have a type library here: [image] ecto_interval Interval Type for Ecto /me loves intervals

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. def filter(...) do # ... |> jo…

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.

Hi @shakram02 [image] 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, This not possible. [image] shakram02: I want to check for 3 conditions when I’m joining two tables. Since …

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.

Hi @OvermindDL1 Thanks for the tip. [image] OvermindDL1: TS indexes Do, you mean creating index with Ecto.Migration.index/2:.

[image] johninvictus: Do, you mean creating index with Ecto.Migration.index/2: . Look at the tsvector/tsquery/etc types in PostgreSQL for efficient word style searches. :slight_smile: I think someone made a library on hex.pm that simplifies it as well, but it’s optional, you can do it in st…