The correct way to filter by an interval in Ash

So are you trying to see how much time is left? I would perhaps return an integer, and using a postgres function to turn the interval into a number of seconds, or something along those lines.

Otherwise, what you could do is not make a calculation that actually returns an interval, and instead make a calculation that tells you if the interval would fit a provided time (which if you want to support longer than one day you’d want to accept an integer amount of seconds).

calculate :interval_contains, :integer, expr(fragment("EXTRACT(EPOCH FROM INTERVAL ?)", retry_at - tried_at) > ^arg(:seconds)) do
  argument :seconds, :integer, allow_nil?: false
end

Then you can do

ten_minutes = :timer.minutes(10) / 1000

Red.Practice.Card
|> Ash.Query.filter(interval_contains(seconds: ten_minutes))
|> Red.Practice.read!()

This way you aren’t surfacing an interval type into your application that you have to figure out how to represent in Elixir via a type.

Thanks for the reply. I was trying to query a list of cards the student is struggling with in order to present that to a parent or tutor.

A small variation on what you suggested was exactly what I needed:

calculate :interval_in_seconds,
              :integer,
              expr(fragment("EXTRACT(EPOCH FROM ?)", retry_at - tried_at))

And then I can query it with:

require Ash.Query

day_of_seconds = round(:timer.hours(24) / 1000)

Red.Practice.Card
|> Ash.Query.filter(interval_in_seconds < ^day_of_seconds)
|> Red.Practice.read!()

And the filtering happens in Postgres, amazing!

Great to see that Calculations accept arguments. Ash is amazing!