How to select the value of this mathematical operation in Ecto query?

Phoenix Forum Questions / Help
, ,
1

How to convert this PostgreSQL query to an Ecto piped select expression:

select CEIL ( CAST ( records."duration" AS DECIMAL ) / 60 ) from records
where "duration" is not null

Thank you.

2

Solved, the way to do it is using fragment.

2 Likes
3

and no code snippet?? :stuck_out_tongue_winking_eye:

4

@Christopher-Shea

Like this:

  Record
    |> select([record], %{
    total: fragment("sum(CEIL ( CAST (? AS DECIMAL ) /60 )) / 2", record.duration)
    })
    |> Repo.one
2 Likes